View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Try =MOD(B16-A16,1)

--
HTH

Bob Phillips

"Svetlana" wrote in message
...
Help me please!
How would i calculate the difference between two times if hours exceed 24.
For example, start time is 10:55, finish time is 01:20. What formula i

have
to use?
Thank you