You want two numbers so you need two formulae. Number of hours = int(7798/60) where int(x) is the integer part of x. Number of minutes = mod(7798, 60) or 7798 - 60*(number of hours) = 7798 - 60*Int(7798/60). Both int and mod are built-in functions in spreadsheets.
1 Hour = (60 * 60) 3600 seconds > so: 7798 / 3600 = 2.166 hours
0 hours, 15 minutes, 0 seconds.
18 hours, 37 minutes, 42 seconds =67,062 seconds1,117.7 minutes18.6283 hours
96 hours, 45 minutes, 10 seconds =348,310 seconds5,805.1667 minutes96.7528 hours
You want two numbers so you need two formulae. Number of hours = int(7798/60) where int(x) is the integer part of x. Number of minutes = mod(7798, 60) or 7798 - 60*(number of hours) = 7798 - 60*Int(7798/60). Both int and mod are built-in functions in spreadsheets.
7,798 seconds is 129.967 minutes.
1 Hour = (60 * 60) 3600 seconds > so: 7798 / 3600 = 2.166 hours
2.166 hours
12600 seconds = 3 hours 30 minutes.
0 hours, 15 minutes, 0 seconds.
18 hours, 37 minutes, 42 seconds =67,062 seconds1,117.7 minutes18.6283 hours
96 hours, 45 minutes, 10 seconds =348,310 seconds5,805.1667 minutes96.7528 hours
127 hours, 30 minutes, 45 seconds =459,045 seconds7,650.75 minutes127.5125 hours
There are 788400 seconds in 3 hours and 39 minutes.
7,777 seconds equates to 2 hours, 9 minutes, 37 seconds.
7542 =125 minutes and 42 seconds 125 minutes = 2 hours and 5 minutes therefore 7542 seconds = 2 hours 5 minutes and 42 seconds.