Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Diff
Stan,
Times are stored as a fraction of a 24-hour day (6:00 = 0.25, 12:00 = 0.5, 18:00 = 0.75, etc). Thus, you can subtract the start time from the end time as normal subtraction. =end_time - start_time Format the result cell as time. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Stan" wrote in message ... I need to calculate the difference between two time fields that are formatted to 'Medium Time'. For example: start time = 12:55 pm end time = 1:57 pm I hoping to return it in an 'hh:mm' format. The above example would return 1:02. Any help you can provide would be most appreciated. Many thanks! |
#2
|
|||
|
|||
Date Diff
Well I forgot to mention I was doing this in Access. When I subtract the end
time from the start time I get 23:28 as a result. I'm using 12:55 pm as the start time and 1:27 pm as the end time. Any thoughts on what I did wrong? "Chip Pearson" wrote: Stan, Times are stored as a fraction of a 24-hour day (6:00 = 0.25, 12:00 = 0.5, 18:00 = 0.75, etc). Thus, you can subtract the start time from the end time as normal subtraction. =end_time - start_time Format the result cell as time. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Stan" wrote in message ... I need to calculate the difference between two time fields that are formatted to 'Medium Time'. For example: start time = 12:55 pm end time = 1:57 pm I hoping to return it in an 'hh:mm' format. The above example would return 1:02. Any help you can provide would be most appreciated. Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions |