|
|
#5
01-26-2017, 04:37 AM
|
|||
|
|||
Hi,
created the cells with time format A and date format B and general C and got #value! so made C number format 2 dec places still get #value! ah solved it, I had done a test lower down and of course the row numbers are not 1 and 1, silly me ! DBenz 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert [h]:mm:ss to Decimal Hours to Count FTE for Month | Ethan2015 | Excel | 2 | 09-18-2015 03:55 AM |
| Formula for decimal hours from two date time entries | DBenz | Excel Programming | 0 | 01-15-2015 05:52 AM |
 Converting decimal to hours
|
jhwtsang | Excel | 4 | 05-16-2011 01:36 PM |
|
Date and time calcs excluding non-working hours
|
mrsatchmo | Excel | 1 | 01-26-2011 08:50 AM |
|
Convert hours in decimal
|
ghostones | Excel | 1 | 12-29-2009 09:17 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode