time conversion to text

[Rhon Alvarez]

Hi Team,

please hep me figure out how to convert time to text format upon pasting to excel:
- here's the scenario, we are retrieving data from a certain application that shows the actual time in minutes and seconds (mm:ss) of a particular person in a certain activity;
- however, upon copying and pasting the data to excel, the said time (mm:ss) is now showing in hh:mm:ss format;
- the minutes value becomes the hh and the seconds value becomes the new mm.

we're having a hard time computing the value as it is not giving us the actual ones. see attached file for your reference.

thanks in advance.

Rhon

 

[Chihiro]

Several ways to handle it.

1. Instead of copy & paste, use import wizard or other means to bring in data. It will allow you to specify data type.

2. Use formula to convert hh:mm:ss to mm:ss, and format as mm:ss.
=M30/60

See attached (N30:N39)