| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on Format in Hour & Minute
Understood.....thank you all
egroups.com... Not strictly accurate, as you CAN do it IF you are happy to use macros and IF the values for time always go in column A and IF the values are always entered incorrectly - but personally, I would look to get people to enter the values in the right format, or to have functions later on that translated what had been entered into the value you wanted (so the input cell asks for minute and will accept whole numbers only, then the formula converts the decimal number into the correct fraction for time) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Format for hours and minutes | Excel Discussion (Misc queries) | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| Format Question Please | Excel Discussion (Misc queries) | |||
| Trailing Space / Format Question | Excel Discussion (Misc queries) | |||
| format question when open csv file | Excel Discussion (Misc queries) | |||
Threaded Mode
