View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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