Convert Time

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
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)
 
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.....
 
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)
 
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)





.
Click to expand...
 
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
 
Back
Top