by JE McGimpsey <jemcgimpsey@[EMAIL PROTECTED]
>
Oct 4, 2008 at 04:22 AM
In article <59b5b7cc.-1@[EMAIL PROTECTED]
>,
spleep@[EMAIL PROTECTED]
wrote:
> 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.
