how to convert 2:30 into 2.5 decimal time? I have the formula

=IF(C8<B8,C8+1,C8)-B8A8 B8 C8 D8

thu 12:00 PM 2:30 PM 2:30Trying 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 here: http://www.consultdmw.com/excel-tim...

or DAGS: Excel convert time to decimal

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll