Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Covert large number to number of hours and mins?

How to convert 68203118 mins into hours and mins or days, hours and mins?

6 Replies
sunny_talwar

What exactly does that number corresponds to?

Update: Is it Minutes or Seconds?

Anonymous
Not applicable
Author

Assuming these are mins:


68203118 divides by 60: will give hours


(68203118 divides by 60) divides by 24 : will give days


what is your requirement??

Not applicable
Author

It is minutes

Not applicable
Author

convert 68203118 mins into hh:mm

sunny_talwar

May be this -> =Interval(68203118/(24*60), 'D hh:mm')

Capture.PNG

swuehl
MVP
MVP

No need to know the number of minutes per hour and hours per day:

=Interval(Interval#(68203118,'m'), 'D hh:mm')