convert hours to days

[RKS]

can I convert 092:06 ........92 hours and 6 minutes to
just days on a spreadsheet.

 

[Frank Kabel]

Hi
one way:
- format the cell as number (1 day = 1) -> 3.84 days for your example

 

[Chip Pearson]

RKS,

Use the formula =INT(A1) and format the cell for General.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Arvi Laanemets]

Hi

When before entering this into cell you formatted the cell as Custom
"[h]:mm", then simply reformat it p.e. as Custom 'd"d "hh:mm'

When your entry is a string, then (let's it be in cell A1) use formula
=TIME((LEFT(A1,FIND(":",A1)-1))*1,(RIGHT(A1,LEN(A1)-FIND(":",A1)))*1,0)
to convert it to time (format the cell with formula like A1 in example
above)

 

[Ozzie]

=CONVERT(A12,"hr","day")

This will give you 3.86 days

 

[Ozzie]

Chip - can you explain this one? using his example I get
92.

 

[Norman Harker]

Hi Ozzie!

I think that you must have entered the time wrong:

=INT("92:06")
Returns: 3

RKS did say that just days were wanted.

Remember that Excel date / time serial numbers are stored as days from
31-Dec-1899 with the decimal part being a decimal part of 1 day.
Taking the Integer of the stored number returns just the days.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.