how do i convert 2:30 into 2.5

August 20, 2012 at 08:07:57
Specs: Windows 7
how to convert 2:30 into 2.5 decimal time?

I have the formula
=IF(C8<B8,C8+1,C8)-B8

A8 B8 C8 D8
thu 12:00 PM 2:30 PM 2:30

Trying to get 2:30 to display as 2.5 as decimal format for payroll
I cannot locate the decimal format under time. I really need stepby step instructions on this.
Oh yh I'm using excel 2007.
Thanks


See More: how do i convert 2:30 into 2.5

Report •

#1
Report •
Related Solutions


Ask Question