Thread: calculate time for employees in 24 hour operation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
daddylonglegs[_15_] daddylonglegs[_15_] is offline
external usenet poster
  
Posts: 1
Default calculate time for employees in 24 hour operation

With startt time in A1 and end time in B1 either

=B1-A1+(A1B1)

or

=MOD(B1-A1,1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513773

Reply With QuoteReply With Quote