adding hours

[spleep]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

have been looking all afternoon for an answer to this but have had no success. I am working on a time sheet. i have a start time and end time. for eg start time is 0800 and end time is 1700. I have formatted the cells to time but what formula would i use if i want to know the total number of hours worked? i need the formula to calculate the 9 hours worked (0800-1700) Any ideas? Many thanks

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

have been looking all afternoon for an answer to this but have had no
success. I am working on a time sheet. i have a start time and end time. for
eg start time is 0800 and end time is 1700. I have formatted the cells to
time but what formula would i use if i want to know the total number of hours
worked? i need the formula to calculate the 9 hours worked (0800-1700) Any
ideas? Many thanks

One way:

A1: 08:00
A2: 17:00
A3: =A2-A1

will produce 09:00 in A3 (format as time if necessary)

If you want the integer 9, then since XL stores times as fractional
days, you should multiply the result by 24 hours/day:

A3: =(A2-A1) * 24

Format as General or Number.

 

[spleep]

thankyou so much for your response, however it gets tricky if my times arent whole numbers, ie: 08:15-17:45. is there a way around that? Thanks again.