Hey, I hope someone can help me ....
I have a column with time in minutes and seconds (eg 1.20) but need that converting in another column into seconds (eg 80).
Please please please can anyone help me????
Hey, I hope someone can help me ....
I have a column with time in minutes and seconds (eg 1.20) but need 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???
You need to enter as 0:1:20
Thank you ... However I know how to add 2 cells together but I need columns A & B which is in minutes adding together and converting to seconds in column c ... Any ideas???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks