Microsoft Office Forums - View Single Post - subtract date and time and convert to decimal hours ?

Thread: subtract date and time and convert to decimal hours ?

View Single Post

Old

01-26-2017, 04:37 AM

DBenz

DBenz is offline

DBenz uses Windows 7 64bit

Windows 7 64bit DBenz uses Office 2010 32bit

DBenz uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

Join Date: Dec 2014

Posts: 69

DBenz is on a distinguished road

Default

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

Reply With Quote