Skip to main content
Solved

Time stamps


I have this table where i get some time stamp called start and end, i split those up into more tabels with start_hour,start_min,end_hour,end_min. There is a time between 12.00 and 12.30 where the people goes to break if they work over the break they get 30 min less in thier total worktime, if they start doing break or end during break i want to make a transformation that subtracts the time spent if they start thier shift in the break. I have 2 fields called Start_in_lunch and End_in_work. I made this into a boolean conditions so if they start or end in lunch it should trigger, how can i do this. I tried some DateDiff with some Timefromparts but with no luck. The simple solution saying Start-30 and end-30 works but doing that devided by 60 does not work. Any good ideers

Best answer by Thomas Lind

Hi Kristoffer

Maybe convert the times to be in minutes instead of hours and minutes.

Then it would be easy to add or remove 30 minutes from the result. In the end you can use a convert function to get it back to hour:minute

View original
Did this topic help you find an answer to your question?

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1027 replies
  • Answer
  • September 4, 2023

Hi Kristoffer

Maybe convert the times to be in minutes instead of hours and minutes.

Then it would be easy to add or remove 30 minutes from the result. In the end you can use a convert function to get it back to hour:minute


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@Kristoffer does the above answer help you resolve the issue? If not, could you please provide some dummy data for the start and end dates and the result you are expecting to get from the transformation


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings