![]() |
#5
|
|||
|
|||
![]()
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 |
|
![]() |
||||
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 |
![]() |
jhwtsang | Excel | 4 | 05-16-2011 01:36 PM |
![]() |
mrsatchmo | Excel | 1 | 01-26-2011 08:50 AM |
![]() |
ghostones | Excel | 1 | 12-29-2009 09:17 PM |