Date & Time

[Steven1985]

<TABLE class=tborder id=post2848959 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 0px solid" width=175></TD><TD class=alt1 id=td_post_2848959 style="BORDER-RIGHT: #ffffff 1px solid"><!-- report button --><HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message -->Column A3 shows Date and Time

30/08/2011 15:07:00

I need in Column AL to replicate that time but change date by 1 day

i.e 31/08/2011 15:07:00

Current formual used is - =IF(A3="","",WORKDAY(A3,1,Controls!$A$10:$A$47)) which changed the date but not the time.

Any ideas?

Thanks
</TD></TR></TBODY></TABLE>

 

[VoG]

Try

=IF(A3="","",WORKDAY(A3,1,Controls!$A$10:$A$47))+MOD(A3,1)

 

[markmzz]

A small modification on the VoG's formula:

=IF(A3="","",WORKDAY(A3,1,Controls!$A$10:$A$47)+MOD(A3,1))

Markmzz

 

[VoG]

Thanks!

I didn't test mine with A3 empty

 

[markmzz]

You are welcome.

Sometimes I forget something also.

Markmzz

 

[Steven1985]

Thats great thanks