Hi All
Im trying look at a start and end time and trying give 5 mins for every completed hour worked
ie if someone worked 02:55 hours then that should return 10 mins as there are only 2 completed full hours but struggling with this formula
Also trying to get a multiple or sumifs to total up every time that isnt in my condition list
hoping you can help me please
many thanks
Im trying look at a start and end time and trying give 5 mins for every completed hour worked
ie if someone worked 02:55 hours then that should return 10 mins as there are only 2 completed full hours but struggling with this formula
Also trying to get a multiple or sumifs to total up every time that isnt in my condition list
hoping you can help me please
many thanks