| Home |
| Search |
| Today's Posts |
|
#14
|
|||
|
|||
Try this:
Steps
Begin by typing in =TEXT( Select or type in the range reference that contains the numeric value you want to convert B3, Divide the numeric value by 24. Type in the format code that includes h, m and s placeholders “[h] “”hours,”” m “”minutes, “” s “”seconds””” Close the formula with ) and press Enter to complete it. Hope this helps. You can get more tips about excel on O365CloudExperts Regards, Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting annual rate of return to quarterly equivalent? | Excel Worksheet Functions | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| Changing Arbic numeral to Hindi numeral | Excel Discussion (Misc queries) | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| How do I Change text (0130PM) into military time equivalent? | Excel Discussion (Misc queries) | |||
Threaded Mode
