| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on Format in Hour & Minute
Dear all,
2 questions please. I have got a spreadsheet to calculate time in hours and minutes A B C 15:00 20:15 5:15 1. When I input "15" in Cell A1, how to format to make it display "15:00" ? 2. Cell C1=B1-A1, similarly, how should B1 & C1 be formatted? Thanks IMS |
| 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
