| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to calculate time difference crossing midnight
In Excel I have been trying to find an easier way to calculate a time
difference where the times cross midnight. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula to calculate time difference crossing midnight
On Thu, 17 Aug 2006 07:16:03 -0700, ditorejax
wrote: In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? One way which results in hours and decimal of an hour is =IF((end-start)<0,(end-start)*24+24,(end-start)*24) If you want to see hours and minutes you'd need to modify it to pick up the decimal fraction and multiply it by 60. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula to calculate time difference crossing midnight
Hi,
one way is add 1 in 00:15:00 assuming that 23:50:00 is on A2 and 00:15:00 is on A3 =a3+1-a2 =00:25:00 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "ditorejax" escreveu: In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula to calculate time difference crossing midnight
=(A2A3)+A3-A2
1 only needs to be added if A2A3 otherwise you get 24 extra hours when times don't go over midnight. You will see the problem when you start summing the times and if you format as [h]:mm:ss "Marcelo" wrote: Hi, one way is add 1 in 00:15:00 assuming that 23:50:00 is on A2 and 00:15:00 is on A3 =a3+1-a2 =00:25:00 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "ditorejax" escreveu: In Excel I have been trying to find an easier way to calculate a time difference where the times cross midnight. Example: Start time: 23:50:00 End time: 00:15:00 How would you formulate an equation to determine the duration of time or differnce between the start and end time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ref: Formula to calculate elapsed time between certain dates and t | Excel Discussion (Misc queries) | |||
| How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Linear Mode
