R
RKS
can I convert 092:06 ........92 hours and 6 minutes to
just days on a spreadsheet.
just days on a spreadsheet.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
one way:
- format the cell as number (1 day = 1) -> 3.84 days for your example
one way:
- format the cell as number (1 day = 1) -> 3.84 days for your example
C
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
Use the formula =INT(A1) and format the cell for General.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
A
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)
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)
O
Ozzie
=CONVERT(A12,"hr","day")
This will give you 3.86 days
This will give you 3.86 days
O
Ozzie
Chip - can you explain this one? using his example I get
92.
92.
N
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.
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.