Try...
=A1*24
....and format as 'General'.
Hope this helps!
In article ,
"tojo107" wrote:
I have Time values in column A i.e 2:30, :45. I want to add a column showing
these times as values. I want column B to show 2:30 as 2.5 hours and :45 as
.75 hours.
Is there a formula I can use?
Thank You!!
|