Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to do a pivot table with the following information.
I have problems to represent the field DurationMinutes like a number with format ###.###
SCHEDULE:
LOAD
ScheduleDate,
START_TIME as ScheduleStart,
END_TIME as ScheduleEnd,
time(DELAY_END_TIME - DELAY_START_TIME,'hh:mm:ss') as Duration,
interval(DELAY_END_TIME - DELAY_START_TIME,'mm') as DurationMinutes
FROM [..\Timing.xls];
I can´t represent the field DurationMinutes like a number.
May be this:
SCHEDULE:
LOAD
ScheduleDate,
START_TIME as ScheduleStart,
END_TIME as ScheduleEnd,
time(DELAY_END_TIME - DELAY_START_TIME,'hh:mm:ss') as Duration,
Num(DELAY_END_TIME - DELAY_START_TIME,'###.###') as DurationMinutes
FROM [..\Timing.xls];
It doesn´t work the result have to be like the filed IncidenceDurationMin with millar point
3
7.203
Hi Ana,
Try this one
num((DELAY_END_TIME-DELAY_START_TIME)*1440,'#,##0.') as DurationMinutes
Try it.
NUM(Interval(DELAY_END_TIME - DELAY_START_TIME,'MM'),'###.###') as DurationMinutes
Regards.
Hi Ana! Try this:
SCHEDULE:
LOAD
ScheduleDate,
START_TIME as ScheduleStart,
END_TIME as ScheduleEnd,
time(DELAY_END_TIME - DELAY_START_TIME,'hh:mm:ss') as Duration,
num(interval(DELAY_END_TIME - DELAY_START_TIME,'mm'), '###.###') as DurationMinutes
FROM [..\Timing.xls];
I hope that it help you !
Hi,
some solutions could be also:
Num(Num#(Interval(IncidenceEnd-IncidenceStart,'mm')),'#.###') as IncidenceDurationMin
Num((IncidenceEnd-IncidenceStart)/'00:01:00','#.##0') as IncidenceDurationMin
rounding minutes off:
Num(Floor((IncidenceEnd-IncidenceStart)/'00:01:00'),'#.##0') as IncidenceDurationMin
Num(Div(IncidenceEnd-IncidenceStart,'00:01:00'),'#.##0') as IncidenceDurationMin
hope this helps
regards
Marco
Thank you so much, this just saved my day!