|
|
#1
12-13-2016, 05:14 AM
|
|||
|
|||
Calculate Time in Hours and Percent
I need a formula that will calculate the total time in Whole Hours & Percent of Hour.
It also needs to calculate over Midnight - 20:00 hrs to 01:30 hrs which should equal 5.5 hrs total time. I have read through some similar issues but cannot find anything to covers the over midnight part. I am using Office 2008 for MAC. Thanks in advance. 
|
| 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 |
Mac OS X 
Office 2008 for Mac
Threaded Mode