Subtracting partial hours

  • Thread starter Thread starter Melissa F
  • Start date Start date
M

Melissa F

I am trying to find the formula that will allow me to subtract partial hours
for an employee schedule (i.e. if the employee worked from 7:30am until 12pm)
what formula can I use to show 4.5 hours?
 
=(end-start)*24

A1 = 7:30 AM
B1 = 12:00 PM

=(B1-A1)*24

Format as General or Number

If the end time might span into the next day (the next day starts at 12:00
AM):

A1 = 7:30 PM
B1 = 12:00 AM

=MOD(B1-A1,1)*24

Format as General or Number
 
Back
Top