Prev: how to remove #n/a error in excel vlookup b/c value is not fou
Next: Calculate next workday after adding calendar days to date in cell
From: Kathie on 5 May 2010 15:14
I have several entries (formatted as text) for example, :31, 1:04, 4:53,
23:34. These numbers indicate minutes and seconds (31 seconds, 1 hour 4
seconds, etc).
What formula can I use to convert these entries into seconds?
From: Fred Smith on 6 May 2010 00:05
If you really meant 1:04 is "1 hour 4 seconds", you've got problems, because
this is indistinguishable from the same entry meaning 1 minute, 4 seconds.
Assuming you meant the latter, use the following to convert to seconds:
=timevalue(a1)*60*24

Format as a number. The Timevalue function isn't really necessary, but I
like to use it because it makes the formula clearer to me.

Regards,
Fred

"Kathie" <Kathie(a)discussions.microsoft.com> wrote in message
news:270FDBEC-6011-4F3C-9777-43E35A4C3F20(a)microsoft.com...
>I have several entries (formatted as text) for example, :31, 1:04, 4:53,
> 23:34. These numbers indicate minutes and seconds (31 seconds, 1 hour 4
> seconds, etc).
> What formula can I use to convert these entries into seconds?

 | 
Pages: 1
Prev: how to remove #n/a error in excel vlookup b/c value is not fou
Next: Calculate next workday after adding calendar days to date in cell