Conversion of Time (URGENT)

[jalifid11]

I've got a spreadsheet that I am trying to make. I downloaded some information from our database, but when excel looks at the information in the cell, it sees it as a date.

It views in the cell looking at it as 2:18, which it should mean 2 minutes and 18 seconds. But within the cell itself, excel is reading it as 12:02:18 AM. Definitely not what I need.

What I need is 2 minutes 18 seconds, because I need to average the time.

Any suggestions?

 

[Scott Huish]

First, that is not a date, but Excel treats time as time, It will always show the equivalent time in the formula bar, but you can treat it as 2 minutes 18 seconds.

 

[jalifid11]

That makes sense.. Is it possible to convert that into seconds?

Such as 2 minutes 18 seconds converts into 138 seconds..

 

[PaddyD]

with your data in a1, in b1:

=a1 * 86400