Search the Community
Showing results for tags 'minutes'.
-
Hello, I'm having difficulty with my time formula for a specific scenario. It is working correctly but producing too much time in some instances. I'm using a calculated field with the following formula to find the total time worked each day: cast (Datediff(hour, [@field:Start_TIme], [@field:End_Time])%24 as varchar)+' hours,'+ cast (Datediff(minute, [@field:Start_Time], [@field:End_Time])%60 as varchar)+ ' minutes' The formula is working when: The time calculated is more than an hour (i.e. 2:00 PM to 4:45 PM) = 2hrs, 45 minutes (CORRECT RESULT)
- 1 reply
-
- time
- calculation
- (and 8 more)
-
I want to show a custom icon based on the minutes difference in a report page if >30 minutes between 30 and 60 mins if more than 60 How can I do it?
- 1 reply
-
- minutes
- time difference
-
(and 1 more)
Tagged with: