1 Hour = (60 * 60) 3600 seconds
>
so: 7798 / 3600 = 2.166 hours
Chat with our AI personalities
2 hrs, 9 mins 58 seconds
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.
72000 seconds
1209600 seconds
122400 seconds