Calculate hour and minutes worked each day

[Allan]

As a novice to Excel I am trying to work out a formula to calculate hours and
minutes worked each day (start and finish) and then at the end of the week
add these times to calculate weekly salary.

 

[Biff]

Try this instead:

If you want the result in time: 8:00, format the cell as [h]:mm

=B3-A3+(B3<A3)

If you want the result in decimal: 8

=(B3-A3+(B3<A3))*24

Biff

 

[David McRitchie]

One more thing when totaling time in the hh:mm format
you want to use [h]:mm to keep the hour from overflowing
into days. when you want to convert to a decimal number
with fractional decimals multiply by 24 and format as a number.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Try this instead:

If you want the result in time: 8:00, format the cell as [h]:mm

=B3-A3+(B3<A3)

If you want the result in decimal: 8

=(B3-A3+(B3<A3))*24

Biff

if a2 isthe start time and B2 is end time in c2 type thisformula
=IF(B3-A3<0,B3-A3+24,B3-A3)
format C2 as time
your can copy this file down keeping the format in column C as Time

====================