how do i convert time to a number in excel

May 5, 2011 at 10:54:02
Specs: Windows Vista
EXAMPLE:
8:00 B2 9:30 C2

D2 needs to be total hours in number format (eg. 1.5)


See More: how do i convert time to a number in excel

Report •


#1
May 5, 2011 at 11:56:27
Format cell D2 as Number
Insert the formula:

=(C2-B2)*24

See how that works.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question