timesheet formula

Hi Sandra-Jane

Welcome to the forum.

See what you think about the attached. I've been able to split the times as described I hope but haven't been able to suss out the totals at the bottom for office use and I'm running out of time now.

Hopefully someone will be able to help if you still have a problem.

Regards

Russell

Hi Sandra-Jane

OK - format D5:E18 as Custom - hh:mm and make sure that when entries are made you are using a colon e.g. 15:00 rather than 15.00. The hours to be calculated for normal and time and a half are correct I assume. Please confirm that it displays and calculates as required. Don't forget, these need to show as what appears to be 24 hour format but really are only showing number of hours worked.

I may need to ask for help on the totals.

Regards

Russell

@Sandra-Jane:

i am not sure how easy or difficult it is to implement for you, my recommendation would be to capture dates related to both start and finish times. otherwise, cases such as Row 11 and 12 versus 13 and 14 would be rendered confusing.

11: 06:00 PM 07:30 PM
12: 07:00 PM 07:30 PM
13: 08:00 PM 07:30 PM
14: 09:00 PM 07:30 PM

in case of 11, it is difficult to say whether the individual works for only 1.5 hours or for 25.5 hours; similarly in 12, 0.5 hour or 24.5 hours.

if you are able to capture finish dates too, the timesheet may be easier to accomplish.

Hi Sandra-Jane

I've had some help on this thanks to Bob Philips and Vlady and it works.

Updated w/s attached

Regards

Russell

Thanks Sandra-Jane, it's nice to know we are appreciated. Please remember to mark the thread as solved.