convert 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)
 
If you actually entered 1:15 AM in the cell (a real time), you could just
multiply by 24.

Remember to format the cell as General (or a custom format of: 0000).
 
Back
Top