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
It would help if you provided more detailed information. If you want to know the most frequently occurring value in a series of text values, you can use something like this:
The formula that returns the most frequently occurring value is
=INDEX(A2:A20,MODE(MATCH(A2:A20,A2:A20,0)))
And the frequency of that value is
=COUNTIF(A2:A20,C2)
- HansVogelaar what is the formula to convert an entire column that is in hours to days?
See NikolinoDE's reply.
- 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. "
