Convert Time

[Brian]

Can someone help me convert 32164 to 8:56:04? I tried
TIMEVALUE(TEXT(A1,"00:\00:\00")) but it comes up as
#VALUE! What am I doing wrong? TIA

 

[Chip Pearson]

Brian,

What does the 32164 represent? How does this represent 8:56:04?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Brian]

It is from a report that I am trying to export to Excel.
When I open the file, 32164 shows up where it should be
reading 8:56:04. hope that makes sense.....

 

[Chip Pearson]

Brian,

OK, I assume that the 32164 is the number of seconds. Given that, you can
convert that to a time with a formula like
=A1/86400
where A1 is the value 32164.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Brian]

Perfect! thanks Chip

-----Original Message-----
Brian,

OK, I assume that the 32164 is the number of seconds. Given that, you can
convert that to a time with a formula like
=A1/86400
where A1 is the value 32164.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)





.

 

[Jane Graves]

My guess is that number is the date, not the time. If you
were to expand the decimals, to see what portion of a full
day that amount of time passed represents, you'd get
32164.372268518518519. You should just be able to format
that number into a time using
format...cells...number...time . If it's not working,
that may be because the number is really text. In such a
case, your formula wouldn't work because you can't take
the timevalue of text. And the timevalue is actually what
you have already anyway. Try:

TEXT(A1*1,"hh:mm:ss"))

Jane