98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Calculating Time
excel training in uk - Calculating Time
Resolved · Low Priority · Version Standard
Tue 4 Sep 2007, 13:43Delegate Roger said...
Roger has attended:
No courses
Calculating Time
can any one help is there a way that I can calculate time very simply
Thank you
Fri 14 Sep 2007, 10:00Trainer Richard said...
RE: Calculating Time
Hi Roger
Time can be calculated in excel by formatting the cell you are using (FORMAT > CELL > GENERAL TAB >TIME), and then entering the time you want. if you create a formula between two cells, say A1 and B1, which have two different times in it, you can get an answer.
So,
=A1-B1
woulds calculate the difference between to times.
Regards
Richard
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding a worksheet in ExcelWant to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view? |
