I need to calculate the difference between 2 or 3 times. Example: Start 9am,
Finish 6pm - how do i format the cells, enter the data in the cells and
calculate the difference to give me a result in time?
I need to calculate the difference between 2 or 3 times. Example: Start 9am,
Finish 6pm - how do i format the cells, enter the data in the cells and
calculate the difference to give me a result in time?
2
Enter time as 9:00 AM and 6:00 pm in say B2 and c2 and use the formula
=b2-c2-0.041667. this assumes a one hour lunch break
Same fomula works for time entered in 24 hour format. e.g. 9:00 and 18:00
regards
Peter
"George" wrote:
> I need to calculate the difference between 2 or 3 times. Example: Start 9am,
> Finish 6pm - how do i format the cells, enter the data in the cells and
> calculate the difference to give me a result in time?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks