|
|
#2
11-18-2016, 10:22 PM
|
||||
|
||||
Without seeing your workbook's structure and some representative content, it's impossible for anyone to give specific advice.
FWIW, though, times are stored as decimal values in Excel. Times before 12 noon are less than 0.5; times after 12 noon are greater than 0.5.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 how to find out hours worked between midnight and 6 am
|
acorn | Excel | 2 | 10-15-2016 01:45 AM |
| Complicated calculation of hours worked | APreston | Excel | 1 | 05-09-2016 04:42 AM |
|
Very complicated calculation of total hours worked (PLEASE HELP)
|
APreston | Excel | 1 | 05-08-2016 02:58 AM |
|
Help with 'hours worked' calculation...
|
Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
| Finding where I last worked on a document. | Balliol | Word | 1 | 11-24-2010 04:50 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode