converting numbers to seconds or minutes

  • Thread starter Thread starter fgr98
  • Start date Start date
F

fgr98

I need enter some numbers in a cell from a hard copy report. The prin
out column is in time format eg Let say cell C1 is 1:14 meaning
one minute and 14 seconds. However I do not want to type type th
colon : I want to type just 114 (to save time in data entry) an
convert that automatically to seconds. I guess I need to create a
input mask first then convert the number to seconds. What formul
will recognize my data entry and convert it to seconds? I guess th
value on the data entry is not time but just numerical value
 
fgr98
You could enter the time in one column and use the following formula to convert it to an Excel time. Time in excel is stored in decimal portions of a day so the numbers won't look right until you apply a time number format (custom mm:ss). You could then Copy the formula column, and Paste_Special>Values to wherever you need the data

=LEFT(A1,LEN(A1)-2)/(24*60)+RIGHT(A1,2)/(24*60*60

Good Luck
Mark Graesse
(e-mail address removed)

----- fgr98 > wrote: ----

I need enter some numbers in a cell from a hard copy report. The prin
out column is in time format eg Let say cell C1 is 1:14 meaning
one minute and 14 seconds. However I do not want to type type th
colon : I want to type just 114 (to save time in data entry) an
convert that automatically to seconds. I guess I need to create a
input mask first then convert the number to seconds. What formul
will recognize my data entry and convert it to seconds? I guess th
value on the data entry is not time but just numerical value
 
Back
Top