Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
I Have column "TIMESPENT" (This column contains seconds)
in my case below one shows(TIMESPENT=127200 seconds) 35h 20min same want see in days like 4 days 3 h 20 min
FLOOR((AVG(TIMESPENT)/3600))&'h'&ROUND(MOD(ROUND(AVG(TIMESPENT)),3600)/60)&'min'
Thanks & Regards,
Nagesh
May be this:
=Floor(127200/28800) & 'day(s) ' & Floor(Mod(127200, 28800)/(60*60)) & 'hr(s) ' & Floor(Mod(Mod(127200, 28800), 3600)/60) & 'min(s)'
=Floor(TIMESPENT/28800) & 'day(s) ' & Floor(Mod(TIMESPENT, 28800)/(60*60)) & 'hr(s) ' & Floor(Mod(Mod(TIMESPENT, 28800), 3600)/60) & 'min(s)'
May be like this:
=Replace(Replace(Replace(Interval(127200/86400, 'D X h U mm Z'), 'X', 'day(s)'), 'U', 'hour(s)'), 'Z', 'min(s)')
=Replace(Replace(Replace(Interval(TIMESPENT/86400, 'D X h U mm Z'), 'X', 'day(s)'), 'U', 'hour(s)'), 'Z', 'min(s)')
Hi Sunny Good Mng!
=Replace(Replace(Replace(Interval(127200/86400, 'D X h U mm Z'), 'X', 'day(s)'), 'U', 'hour(s)'), 'Z', 'min(s)')
here Day taking 24 hrs, i want to calculate day as 8hrs only
Regards,
Nagesh
May be this:
=Floor(127200/28800) & 'day(s) ' & Floor(Mod(127200, 28800)/(60*60)) & 'hr(s) ' & Floor(Mod(Mod(127200, 28800), 3600)/60) & 'min(s)'
=Floor(TIMESPENT/28800) & 'day(s) ' & Floor(Mod(TIMESPENT, 28800)/(60*60)) & 'hr(s) ' & Floor(Mod(Mod(TIMESPENT, 28800), 3600)/60) & 'min(s)'