custom number format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 20 Aug 2007 21:55 GMT

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

Reply to this Message

Pete_UK - 20 Aug 2007 22:07 GMT

Chip Pearson shows how here:

http://www.cpearson.com/excel/DateTimeEntry.htm

Hope this helps.

Pete

> Hello
>
[quoted text clipped - 3 lines]
> Thank you
> David

Reply to this Message

Sandy Mann - 20 Aug 2007 22:13 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Hello
>
[quoted text clipped - 3 lines]
> Thank you
> David

Reply to this Message