Question

Locked

Time Fomat in Excel 2003

By K.Grass ·
Hi,

I'm looking for a custom format (or whatever else works) that would turn a four digit number into a formatted time.

For example: A user types in 1030 into cell A1 for the amount of hours put into a work day and once he/she hits the Enter key cell A1 changes to 10:30.

This is necessary to facilite Excels other time formulas for calculation. Is it possible?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums