Subtracting partial hours

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

 

[T. Valko]

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