Calculate hour and minutes worked each day

[Guest]

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.

 

[R.VENKATARAMAN]

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

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

 

[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.

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

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