I am in the process of creating a calendar. This calendar is to track leave hours for employees. For example if a person takes leave for 2.5 days then the formula would calculate 8hrs per day and 4 hours for half a day = 20hrs. I have
part of the formula I believe "=TEXT([End Time]-[Start Time],"h")". The problem is that it does not count multiple days and just not working right. Any advice would help.
View Complete Post