Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone suggest me how to convert value 454435 into minutes?
I have used below not sure whether correct or not?
=Sum(interval(Salestime/60, 'mm'))
Thanks.
TRY THIS
=Interval(Sum(45443/60),'D hh:mm')
replace 45.... with expr
=interval(interval#(454435, 'ss'), 'mm')
Thanks. what D means?
seems it's assuming as Day,the above syntax is worked for u?
Thanks. actually It is not day. it is seconds.
can you let me know can I use the above expression if I have data as below
84842572646
5546835867579
4567265746
Thanks. how to change the same expression if I need to convert into weeks, days, hours,minutes
Please let me know.
You can use the following symbols to format a date. Arbitrary separators can be used.
D | To describe the day, use the symbol "D" for each digit. |
M | To describe the month number, use the symbol "M".
|
Y | To describe the year, use the symbol "Y" for each digit. |
W | To describe the weekday, use the symbol "W".
See: DayNames and LongDayNames |
Examples: (with 31st March 2013 as example date)
YY-MM-DD | describes the date as 13-03-31. |
YYYY-MM-DD | describes the date as 2013-03-31. |
YYYY-MMM-DD | describes the date as 2013-Mar-31. |
DD MMMM YYYY | describes the date as 31 March 2013. |
M/D/YY | describes the date as 3/31/13. |
W YY-MM-DD | describes the date as 6 13-03-31. |
WWW YY-MM-DD | describes the date as Sat 13-03-31. |
WWWW YY-MM-DD | describes the date as Saturday 13-03-31. |
You can use the following symbols to format a time. Arbitrary separators can be used.
h | To describe the hours, use the symbol "h" for each digit. |
m | To describe the minutes, use the symbol "m" for each digit. |
s | To describe the seconds, use the symbol "s" for each digit. |
f | To describe the fractions of a second, use the symbol "f" for each digit. |
tt | To describe the time in AM/PM format, use the symbol "tt" after the time. |
Examples: (with 18.30 as example time):
hh:mm | describes the time as 18:30 |
hh.mm.ss.ff | describes the time as 18.30.00.00 |
hh:mm:tt | describes the time as 06:30:pm |
The same notation as that of dates and times above is used in time stamps.
Examples: (with 31th March 2013 18.30 as example time stamp):
YY-MM-DD hh:mm | describes the time stamp as 13-03-31 18:30 |
M/D/Y hh.mm.ss.ffff | describes the time stamp as 3/31/13 18.30.00.0000 |
Maybe I'm missing something, but why not just divide by 60:
Salestime/60