Calculate hour and minutes worked each day

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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


Biff said:
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

R.VENKATARAMAN said:
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

====================
 
Back
Top