converting working hours to days



I have 2 dates / times in colums C and L formatted mm/dd/yyyy hh:mm:ss
In column P I am using the formula
to work out working hours between the two date/times. this gives me hours and
mins ok.
in column V I need to convert this to days (working day =10 hours), i am
using the formula =DAY((P2*2.4)+1), this works ok upto 309 hours which
returns 31 days, after that it starts at 1 again, how can i get it to keep
counting the days past 31


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question