custom number format

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello

I want to format a cell so that the user could enter in a time without
having to enter in the colons. Can this be done? Ie. 1400 = 14:00


Thank you
David
 
To make the entry *look* like a time use the Custom format #0\:00

But the cell will still hold the original entry. To use it as a time divide
it by 2400 EVERY time that you use it in a calculation.

For example

F4: 800
G4: 1400
H4: =G4/2400-F4/2400

H4 formated as time

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top