Off Belay forum

View latest messages in My Forums
This topic has been archived, and won't accept reply postings.

Topic - Excel wizards of the world unite - date calculation problem

G. Tiger, Esq. - on 14 Feb 2013
Hi All,

I'm hoping that some of you clever chaps can help me out.

I've got a data set with lots of dates and times in, and need to calculate the working days between the two. I've googled for most of the afternoon and can only come up with workdays between two dates which gives me whole numbers.

The formula in which it needs to be is:

=IF(P65=2, D65-D64,"")

Where P65=2 defines whether it is the first and second dates in that particular transaction, and D65 is the time and date of the second transaction, and D64 the time and date of the first.

I need the data presented as a fraction of the work days taken to process.

Is this possible, or am I just dreaming the impossible dream?

If it helps, I have the days of the week in a separate field, could they be used to modify the data appropriately?

cheers all, GTE
... not showing 8 replies to this topic ...
Register as a New User or login to gain full access to the forums. Registration is quick and completely free.
If you are definitely logged on, press Ctrl+F5 keys to reload this page [read more]

Unregistered users can only read messages in the most recent topics.

This topic has been archived, and won't accept reply postings.

My Forums