Converting minutes to seconds

  • Thread starter Thread starter youngxxi
  • Start date Start date
Y

youngxxi

Hey, I hope someone can help me ....

I have a column with time in minutes and seconds (eg 1.20) but nee
that converting in another column into seconds (eg 80).

Please please please can anyone help me???
 
Is it 1.20 or 1:20?

If the former

=DOLLARDE(A1,60)*60

note: DOLLARDE function requires Analysis ToolPak to be enabled

if the latter then how is the cell formatted? if h:mm then

=A1*1440 format as general

If m:ss

=A1*86400 format as general
 
When I am entering the time in as 1:20 and format the cell to m:ss it is
changing the value to 20:00, any ideas why??? :confused:
 
Thank you ... However I know how to add 2 cells together but I nee
columns A & B which is in minutes adding together and converting t
seconds in column c ... Any ideas??
 
Back
Top