Forum Discussion
Solved
dispaly Duration
Hi All... Help needed one more time. I have two Time columns in my table.I want to find the difference of time and append this duration with some text. time1 time 2 re...
Hi Dain,
Try out this formula please.
remarks = VAR minutes = DATEDIFF ( [time1], [time2], MINUTE ) VAR h = INT ( minutes / 60 ) VAR m = MOD ( minutes, 60 ) RETURN IF ( h = 0, "Duration is " & m & " Minutes", "Duration is " & h & " hours " & m & " Minutes" )
Best Regards,
Dale
Hi Dain,
Try out this formula please.
remarks =
VAR minutes =
DATEDIFF ( [time1], [time2], MINUTE )
VAR h =
INT ( minutes / 60 )
VAR m =
MOD ( minutes, 60 )
RETURN
IF (
h = 0,
"Duration is " & m
& " Minutes",
"Duration is " & h
& " hours "
& m
& " Minutes"
)
Best Regards,
Dale
Thank You so much for the Answer!.
I am struggling to implement another logic.Could you please have a look on it.
I have a date slicer with start and end dates.I want to find the first working day of month for each months tat comes in that slicer start n end dates.For each first working day,i want to execute a specific logic.How can i do it dynamically
Hi Dain,
My pleasure. Seems it's a new topic. I would suggest you create a new thread in this forum. If you can post a sample, that would be helpful for the community to work out an answer.
Best Regards,
Dale