Can i change the time stamp on EOMonth Formula

[Nikijune]

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

 

[oldbrewer]

your workday formula returns a date
is the time critical ? if not completion date is a date and if completion date greater than due date then SLA breached
you can add say 11:00:00 to your workday date of course

 

[Tetra201]

Maybe

=WORKDAY(EOMONTH($D$1, -1),1)+17/24