topic Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift. in App Development

Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Sxbbb — Fri, 15 Nov 2024 20:53:05 GMT

I have Field

DurationTime(Min) :

Morning shift time 06.00-13.59 hrs. Afternoon shift 14.00-21.59 hrs. Night shift 22.00-05.59 hrs.

Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

example
TimeStartDowntime ='11:42:40' TimeFinishDowntime ='23:03:38' Want to calculate by shift.

Morning shift StartDowntime ='11:42:40' - '13.59' = ? Min
Afternoon shift '14.00'- '21.59' = ? Min
Night shift '22.00 '- FinishDowntime ='23:03:38' = ? Min

The unit is minutes.

Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Kushal_Chawda — Tue, 27 Aug 2024 09:16:14 GMT

@Sxbbb Do you want Minutes by shift like Morning Shift Minutes, Afternoon Shift minutes.. or do you want overall minutes?

Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Sxbbb — Tue, 27 Aug 2024 09:29:04 GMT

want Minutes by shift like Morning Shift Minutes, Afternoon Shift minutes..

Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Sxbbb — Tue, 27 Aug 2024 09:39:01 GMT

Do I have to do field shift as well?

Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Padma123 — Tue, 27 Aug 2024 13:08:06 GMT

for minutes difference-

((Hour(TimeFinishDowntime))*60+Minute(TimeFinishDowntime))
-
(( Hour(TimeStartDowntime))*60+Minute(TimeStartDowntime))

for shifts wise use interval match

Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Sxbbb — Wed, 28 Aug 2024 02:22:48 GMT

I want to bring time TimeStartDowntime to TimeFinishDowntime is divided into shifts. What should I do?

I need shift field = Morning Afternoon Night

What do I have to do?

Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Sxbbb — Wed, 28 Aug 2024 02:32:45 GMT

The shifts are morning, afternoon, and night.

Re: Want to calculate time from TimeStartDowntime to TimeFinishDowntime Calculated in minutes by shift.

Padma123 — Wed, 28 Aug 2024 07:24:56 GMT

I hope it is helpful

table1:

load *,Hour(timedown) as hourtimedown,

Minute(timedown) as mintimedown,

Hour(timestart) as hourtimestart,

Minute(timestart) as minutestimestart;

load * inline [

timestart,timedown

06.00.00,13.00.00

06.00.00,07.00.00

14.00.00,15.00.00

]

;

shift:

load * inline [

shiftstart,shiftend,shift

06.00.00,13.59.00,morning

14.00.00,21.59.00,after

22.00.00,05.59.00,nyt

];

IntervalMatch(timestart)

load shiftstart,shiftend

Resident shift;