Forum Discussion
Converting hours:minutes to minutes
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 tim...
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)
Thanks PeterBartholomew1 much appreciated.
