calculating shift timing -VBA

February 20, 2012 at 20:38:57
Specs: Windows XP
HI All ,

I would like to pick the shift timing from the given shift.

agent name:ABC
Start time: 02:20:30 PM
End time: 12:02:05 AM

Could someone please help me in calculating the shift of these kinds.

Regards,
Preetpal


See More: calculating shift timing -VBA

Report •


#1
February 20, 2012 at 21:23:05
convert to 24 hour clock with date.

Report •

#2
February 21, 2012 at 06:52:42
I have got the solution....

=MOD(a1-b1,1)


Report •
Related Solutions


Ask Question