Calculate the difference between two times
 

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

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

Thank you for your reply.
Could you help me with the next thing, please

Start time finish time Difference
10:05:00 18:40:00 8:35:00
20:00:00 04:05:00 8:05:00
15:20:00 00:45:00 9:25:00
Total:
When i do autosum my Total: 02:05:00
How to sort this problem out?
Thank you.

You got a couple replies at your other post.

Svetlana wrote:

Thank you for your reply.
Could you help me with the next thing, please

Start time finish time Difference
10:05:00 18:40:00 8:35:00
20:00:00 04:05:00 8:05:00
15:20:00 00:45:00 9:25:00
Total:
When i do autosum my Total: 02:05:00
How to sort this problem out?
Thank you.

--

Dave Peterson