Hi,
i have a log withe time records in minutes and seconds.
log format is .csv
example entries:
12:33 (12 minutes 33 seconds)
05:46
22:24
when i open this log in excel, the time cells are showed as hh:mm:ss, for example 12:33 is shown as 12:33:00
how do i make excel take this data as mm:ss ?
thanks
Bookmarks