Hello, just need to Convert Hours into Days, for example on cell Q13 I have total sick hours used for the year in Hours now shows 13.5 cell formatted as General, I like to have it display as " 1 Day & 5hr. 50min "
Thank you
Hello, just need to Convert Hours into Days, for example on cell Q13 I have total sick hours used for the year in Hours now shows 13.5 cell formatted as General, I like to have it display as " 1 Day & 5hr. 50min "
Thank you
Your expected answer cannot be correct. 0.5 hours is 30 minutes, and not 50. Or do you want 1 Day & 5.5 hourss
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Maybe this??
=IF(INT(A1/8)=1,INT(A1/8)&" Day & ",INT(A1/8)&" Days & ")&IF(MOD(A1,8)=1,INT(MOD(A1,8)/1)&" Hour &"&MOD(MOD(A1,8),1)*60& " Minutes",INT(MOD(A1,8)/1)&" Hour & "&MOD(MOD(A1,8),1)*60&" Minutes")
place this code into a module , then in the cell provide the time in seconds
usage:
=ElapsedTimeAsText(e23)
Please Login or Register to view this content.
Im sorry your correct its 30min
Thank you its exactly what I needed.
Thanks you
is there a way I can fix this
"1 Day & 4 Hour & 30.0000000000002. Minutes"
Try this formula
=INT(A1/8)&" Day(s) "&TEXT(MOD(A1,8)/24,"h"" Hours ""m"" Minutes""")
Audere est facere
Cool thank you
Please bare with me, I have one more question on how to get 1.30 instead of 1.50, what I have now is calculating sick hours used out of 40hrs. total but instead of h.15 it shows h.75. instead of h.30 it shows h.50
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks