Forum Discussion
BBBC1980
May 21, 2019Copper Contributor
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...
PeterBartholomew1
May 21, 2019Silver Contributor
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)
- BBBC1980May 22, 2019Copper Contributor
Thanks PeterBartholomew1 much appreciated.