Formula to calculate time
Use 2 columns, one with start and one with end time, then use
for instance start in A, end in B and total in C
=B2-A2
will give you the hours unless you need to deduct lunch as well
Then you can just total all hours like
=SUM(C2:C6)
for a week
use custom format [hh]:mm to display hours greater than 24
--
Regards,
Peo Sjoblom
"Helen" wrote in message
...
I have the hours worked in Column A (i.e., 8:00 - 5:00) and the total hours
in Column B (8.0). Is there a formula for Column B that will calculate
that
for me, or will I have to use two columns for the hours worked (start time
and end time) AND use military time in order to do a simple math function
formula?
Thanks for your help!
|