Forum Discussion
Entering time duration in Minutes and seconds
hey all, Ive done this before but I cant seem to remeber or even find the custom format to do it again. I am attempting to imput time duration into my spreedsheet. To be specific I am attempting ...
An alternative strategy might be to convert the 4-digit number to a time value.
A traditional spreadsheet would require
= (QUOTIENT($C3,100)+MOD($C3, 100)/60)/60/24
whilst Excel 365 could be
= LET(
hrs, QUOTIENT(+PseudoTimes,100),
mins, MOD(PseudoTimes, 100)/60,
(hrs+mins)/60/24)
and 365 beta
= Timeλ(PsudoTimes)
where the Lambda function is defined by the second formula.