Formula to calculate time

[Guest]

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!

 

[Peo Sjoblom]

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