Results 1 to 1 of 1

Thread: Help required

  1. #1

    Help required

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Team,

    I am trying to calculate login hours of and employee based on their login hours the segregation is <3:00:00 hrs is 0, >3:00:00 & < 6:00:00 is 0.5 & >6:00:00 is 1. Where 0,0.5 & 1 are count of days.Whenever i am viewing the login hours in pivot for the day wherever the count of days is 0.5 the staff time is getting doubled (when divided by 0.5..EX:- 3:05:00/0.5 is giving 6:10:00)& wherever the count of days is 0 it is reflecting as error, it is giving correct value for 1. My requirement is the staff time for 0.5 & 0 should reflect the same for the day and whenever we are calculating for multiple days staff time needs to be divided by sum of days.

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts