May 21 2019 09:23 PM - edited May 21 2019 10:36 PM
Thanks in advance. I can't find how to convert 2:55 to minutes. I'm designing a data collection sheet and i have figured out how to deduct the start time from the finish time to give an elapsed time formatted as 2:55. How do I convert this to 175 minutes?
May 21 2019 11:03 PM
May 21 2019 11:57 PM
If, for some reason, you choose not to rely upon the knowledge that times and durations are represented as fractions of a day, you could use the longer formula
= 60*HOUR(Duration) + MINUTE(Duration)
May 22 2019 02:50 PM
Thanks @Peter Bartholomew much appreciated.