|
|
#2
12-13-2016, 06:29 AM
|
||||
|
||||
The over midnight calculation can be obtained using =MOD(end_time-start_time,1)
Quote:
What do you mean by "Whole hours and % of an hour". What should the result look like?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
| Tags |
| time calculation |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem) | stormrider2230 | Excel | 1 | 01-20-2016 01:41 PM |
 Calculate Average Time Elapsed in Days, hours and minutes
|
Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
|
Need a formula to calculate turnaround time in hours
|
ram_cl1981 | Excel | 5 | 09-29-2014 02:20 PM |
|
Calculate difference by days and hours
|
alysolyman | Excel | 6 | 05-13-2013 02:19 AM |
|
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode