converting hh:mm:ss to decimal

  • Thread starter Thread starter Mark Cain
  • Start date Start date
M

Mark Cain

is it possible to format a cell so that if I enter the time as 1.15 am it
converts it to 0125 or if I enter the time as 2.45 pm it converts it to
1475. if anybody could help me with this it would be very much appreciated

(e-mail address removed)
 
With your time values in A1

=A1*2400

format as 0000

not that 01.35 (assuming you use period as time delimiter as opposed to
colon)
will return a value with decimals so you might want to round to nearest
integer

=ROUND(A1*2400,0)

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top