Re: Excel (1457419)		Home · Maps · About
Home > SubChat
	[ Read Responses | Post a New Response | Return to the Index ] [ First in Thread | Next in Thread ]

view flat

Re: Excel

Posted by Bill West on Thu Dec 7 22:04:42 2017, in response to Re: Excel, posted by BusRider on Thu Dec 7 10:56:43 2017. Is this a case of overtime starts after 8 hours of working or 11 hours since starting, whichever comes first? If so I think we would need a cell for this: "OT kicks in at"=MIN("time 8hrs is up","time 11hrs is up") And then calculate ST hours up to that cell and OT hours on from it. If there was any real world way for the midday break to occur later than either of those times then we might have to do more with the calculation. Bill

Responses

• Re: Excel - BusRider - Thu Dec 7 22:49:30 2017
  • Re: Excel - Bill West - Sat Dec 9 02:26:16 2017
    • Re: Excel - BusRider - Sat Dec 9 13:41:47 2017
      • Re: Excel - Bill West - Sun Dec 10 02:32:05 2017
        • Re: Excel - BusRider - Sun Dec 10 10:00:42 2017
          • Re: Excel - Bill West - Sun Dec 10 14:10:49 2017
            • Re: Excel - BusRider - Mon Dec 11 11:28:38 2017
              • Re: Excel - Bill West - Mon Dec 11 15:31:05 2017
                • Re: Excel - BusRider - Thu Dec 14 22:11:10 2017
                  • Re: Excel - Bill West - Thu Dec 14 23:16:05 2017
                    • Re: Excel - BusRider - Fri Dec 15 11:09:34 2017
                      • Re: Excel - Bill West - Fri Dec 15 13:33:02 2017
                        • Re: Excel - BusRider - Sat Dec 16 12:20:53 2017
                          • Re: Excel - Bill West - Sat Dec 16 15:13:44 2017

Post a New Response