subtract time

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,565
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
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,643
Office Version
365
Platform
Windows
Another possibility
=24*(B1+(B1<A1)-A1)
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,082
Messages
5,466,535
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top