converting Minutes & Seconds into seconds
 

When my time is 10 minutes and 50 seconds how can I convert the time into
seconds?

converting Minutes & Seconds into seconds
 

Depends upon how the 10 mins 50 secs is entered.

I have 00:10:50 in A1

In B1 enter =A1*86400

I have 10:50:00 in A1

In B1 I enter =A1*1440

Format as General.........returns 650


Gord Dibben MS Excel MVP


On Fri, 11 Dec 2009 10:46:01 -0800, Joe
wrote:

When my time is 10 minutes and 50 seconds how can I convert the time into
seconds?