Calculate the difference between two times

G

Guest

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
 
G

Guest

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.
 
D

Dave Peterson

You got a couple replies at your other post.
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate After hours 3
Calculate the difference between two times and show dd:hh:mm:ss 7
Time difference between two times 1
Calculate the difference between two times 1
Calculate the number of seconds between two times 1
calculate difference between two times 6
Calculate elapsed time excluding specific timeframe 10
to calculate the difference between sign in and signout time in minutes. 5

Top