![]() Popular Features: Find/Highlight/Identify Duplicates | Delete Blank Rows | Combine Columns or Cells without Losing Data | Round without Formula . Is the above possible with formula for weekdays and different formula for weekends where there is no deduction of 15min for lunch time? Thanking you in advance for your help and time.Supports Office/Excel 2007-2021 and 365 | Available in 44 Languages | Easy to Uninstall Completely If it was a weekend this hours will be 6.38 but must be displayed as 6.75 (the nearest quarter on the clock). If he is Kate and clocks in at 09:22 and clock out at 16:00 his hours to be paid wil be ((16:00-09:22)less 15min) displayed as 6.23, but I need to get it to the closest fraction display as 6.25.(the nearest quarter on the clock) If a person’s total time spend is 8hours and 17 min I need a formula yo show it as 8.25 (17min as a fraction of. I followed various tries but it does not work the way I need it to work. My challenge is that it must be displayed as 8.75 and not 8,45. ![]() Can you help me getting the correct formula for time worked when people clock in and out but only get paid for set hours? e.g, clock in 06:20 – clock out 16:25,but only get paid from 07:00 to 16:00,less 15min for lunch? (they get 45min lunch, but they wanted 1 hour lunch so they sacrifice 15min).thus they get paid only for 8.75hours.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |