| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
| How can I calculate the difference between times without using th. | Excel Worksheet Functions | |||
| how do i calculate minutes between two times? | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Linear Mode
