Re: Excel (1457295)		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 01:26:02 2017, in response to Re: Excel CORRECTION, posted by BusRider on Wed Dec 6 21:02:11 2017. If you mean you now have C8=IF(AND(C5<"8:00",C5>"8:00"),0,MROUND(C5-"8:00","0:15")*24), I think it will still stall when C5 is 7:55. Maybe I'm not correctly following your update. C7=IF(C5>0,"8:00",0) and C8=MAX(C5-"8:00",0) should separate the straight time and overtime. Bill

Responses

• Re: Excel - BusRider - Thu Dec 7 10:56:43 2017
  • Re: Excel - Bill West - Thu Dec 7 22:04:42 2017
    • 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