Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convertin hours into days, hours and minutes
Common question and I've looked at a number of different answers in the
forum. None quite work for me though. I can get the days part ok using INT, its the leftover hours and minutes which is giving me grief" The following nearly gets the =INT((Q5/7.5)*24)&" day "&TEXT(MOD(Q5,7.5),"hh"" hours"" mm"" minutes""") However with 15:13 (hh:mm) in cell Q5, the result is 2 d 15h 13m rather than 2d 0h 13m Any ideas? -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
converting hours to days,hours,minutes | Excel Worksheet Functions |