Collecting a total value of a specific from specific hours and number of days

Hi

I am trying to create a a spreed sheet where the start date is entered into one field, the start time is entered into another, followed by the finish date and the finish time entered into the next columns of fields.

Then a output of information stating the number of days that this has taken between the two times and the number of hours.

But set with a specific number of days being that of only 5 being that of the working week instead of 7 and the number of hours being that of 10 working hours instead of the standard of 24 hours.

Any help would be greatly appreciated

Hi jexzard

Welcome to the forum.

Does the attached meet your requirements?

Regards
Alastair

Thank you Alastair

yes that is just what i needed

many thank

Jexzard