hi
I have a spreadsheet that is a timesheet,have formula that starts at 00:00 and goes to 16:30, 00:00 to 06:00 is double time ,07:00 to 08:00 is time and half
this works ,but if I try to enter after 16:30 it goes all wrong, how can I do a formula that starts after 16:30 to 24:00,that takes into account 16:30 to 1900 is time and half and 1900 to 24:00 is double,can excel determine what time it is and what rate it should be looking at
cheers colin