Hi Team,
I want to calculate time in hours between two date time like on
18th 8am to 18th 10am :- 2 hours
18th 12pm to 18th 8pm :- 8 hours
total :- 10 hours
Can anyone please help calworkhours is not working properly.
Discussion posts and replies are publicly visible
Please explain what "not working properly" actually means.
its gives value as 1 if we consider 8 am to 10 am , but I want 2
Not sure why its giving me something different
Timezone? Working hours in calendar?
Unknown said:Working hours in calendar?
It's probably this. I just tried it on my system and the results seemed finnicky (i don't think we actually use this function anywhere, luckily) - i checked our system calendar and noticed it's set to use working hours in GMT for some reason. I assume this might be true for many people who don't realize it.