Comparison of Time
Hi Max,
Am Sun, 13 Aug 2017 12:03:08 -0700 (PDT) schrieb Max:
my data is like this
01-Aug-17
Employee In_Time Out_Time Minutes
1 9:35 18:00 505
2 9:20 17:58
3 9:15 19:15
another suggestion:
=IF(COUNT(B2:C2)<2,"",MOD(C2-B2,1)*1440)
Regards
Claus B.
--
Windows10
Office 2016
|