Forum Discussion
Solved
How do I find Origin of an excel sheet?
I am trying to answer this question>What is the most common origin? How many cases have that origin?
If B1 contains a umber of hours, for example 36, you can use
=B1/24
to return 1.5 as the number of days
I apologize, I am very novice to Excel. If I have Column b1:b166, how do I add that to the formula's below?
=INT(C2/24*60) & " Days " & MOD(C2/24*60,1)*24 & " hours"
or
=INT(C2)&" days "&TEXT(C2-INT(C2),"h:mm")&" hrs. "
=INT(C2/24*60) & " Days " & MOD(C2/24*60,1)*24 & " hours"
or
=INT(C2)&" days "&TEXT(C2-INT(C2),"h:mm")&" hrs. "
If B1 contains a umber of hours, for example 36, you can use
=B1/24
to return 1.5 as the number of days
- @@Hans Vogelaar and @@NikolinoDE Thank you both so much! Have great day!