Hello,
I am hoping this is a really simple one. I have tried searching the world wide web for the answer, however, I am a bit poorly today and not functioning properly.
I have the following formula;
=WORKDAY(EOMONTH($D$1, -1),1)
Which gives the date that a report is due by. I am then updating another cell with the actual date and time the report is completed, and in the format DD/MM/YYYY HH:MM:SS.
I have another cell that then works out if the report was completed within SLA or not, which it currently says is out of SLA even though its not and I think it is because my 'actual' has a time stamp on it, where as the EOMonth formula shows the time as 00:00:00....
So, my question is, can I do something to my formula that makes the time something else, ideally 17:00:00?
Thanks in advance![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am hoping this is a really simple one. I have tried searching the world wide web for the answer, however, I am a bit poorly today and not functioning properly.
I have the following formula;
=WORKDAY(EOMONTH($D$1, -1),1)
Which gives the date that a report is due by. I am then updating another cell with the actual date and time the report is completed, and in the format DD/MM/YYYY HH:MM:SS.
I have another cell that then works out if the report was completed within SLA or not, which it currently says is out of SLA even though its not and I think it is because my 'actual' has a time stamp on it, where as the EOMonth formula shows the time as 00:00:00....
So, my question is, can I do something to my formula that makes the time something else, ideally 17:00:00?
Thanks in advance