| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Problem converting Hours to Days, Hours, Minutes
Thank you all very much for your replies. Bruce nailed it with this simple
equation. I guess I just didn't understand how this simple formula worked. Thanks again! Z "bpeltzer" wrote: If these are proper times in Excel, you should be able to use its built-in functions: =DAY(G21) & " days, " & HOUR(G21) & " hours, " & MINUTE(G21) & " minutes" --Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Threaded Mode
