Hello,
How do you convert a certain amount of time into minutes in a regular number format?
For example, I would like to convert "02:53:00" into "173".
Thanks,
David
EDIT: title should read "hh:mm:ss"
Hello,
How do you convert a certain amount of time into minutes in a regular number format?
For example, I would like to convert "02:53:00" into "173".
Thanks,
David
EDIT: title should read "hh:mm:ss"
Last edited by blackmilk; 08-25-2012 at 04:56 PM. Reason: EDIT: title should read "hh:mm:ss"
Custom format the time cell as [m] and you'll get total minutes......or with a formula in another cell try
=A1*1440
where A1 contains your time value - format as general
Audere est facere
=A1*1440 and format as Number
Entia non sunt multiplicanda sine necessitate
Awesome, that formula was exactly what I needed.
Thanks![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks