Hi
Could you please help me how can I convert from 224,064 minutes to hours ? so the easy rule is 224,064/60= 3,7344 hours.
But I would like to read this as 3:44 mins, I tried searching , but no success
Hi
Could you please help me how can I convert from 224,064 minutes to hours ? so the easy rule is 224,064/60= 3,7344 hours.
But I would like to read this as 3:44 mins, I tried searching , but no success
I think I found out myself =3,7344/1440*60=3:44
224,064/60/24 then format the cell as h:mm
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
thanks tanasedn
Formula:=time(int(a1/60),int(mod(a1,60)),round((mod(a1,60)-int(mod(a1,60)))*60,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks