|how to convert 2:30 into 2.5 decimal time?|
I have the formula
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.