Tag Archives: ROUNDDOWN

Time Conversion – How to convert 24hr input as 4-digit number into TIME in Excel?

How to convert something like 1200 into 12:00? For easy sake of input, we often input 24-hr time as four digit number like 930 for 9:30, 1815 for 18:15 etc.  However, if time is input in this way in Excel, … Continue reading

Rate this:

Posted in Excel Tips, Format | Tagged , , | 12 Comments