subtract time

[lezawang]

Hi
I want to find how many hours a user worked. The start time was A1= 10:00 pm and shift finished B1=1:00 am, so this user worked 3 hrs, so when I did

C1 = 24 * (B1-A1)

I got ################.......

How that can be fixed.

Thank you very much

 

[jasonb75]

Try

=MOD(B1-A1,1)*24

 

[Peter_SSs]

Another possibility
=24*(B1+(B1<A1)-A1)