How to sum half day, in the WORKDAY function?

Anderson · Oct 5, 2004

Is there a possibility to sum hours to the workday function?!
Ex:
10/11/2004 12:00AM
+1.5 (one and a half day)
= 10/12/2004 12:00PM

is it possible?!

Frank Kabel · Oct 5, 2004

Hi
try
=WORKDAY(A1,1)+0.5/24

Niek Otten · Oct 5, 2004

Yes.

To learn all about calculating with dates and times, visit

http://www.cpearson.com/excel/datetime.htm#AddingDates

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel