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
Not very helpful but I think calworkhours() is literally calculating a "between" value which means that one of the boundaries (probably the end_datetime) is not being included. An example: between 8am and 10am is actually 1hour and 59 minutes and 59 seconds. I can see that if I do this:
calworkhours( fn!todatetime("18/07/2022 8:00 am"), fn!todatetime("18/07/2022 10:01 am"), )
then I get this;
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.