Can these formulas be combined into 1

[frazzle6]

Hi Guys and girls

I have 2 formulas that i use regularly. I have a date in column c and a time in column d which i combine =C2+D2

Simple works well. Problem it;s in GMT so a dd 10 hours for sydney time. Let say the result for the 1st formula is in H2, so i use

=H2+TIME(10,0,0), gives me sydney date and time. All good. Is the a way to combine this so as it does it all at once?

Cheers thanks in advance.

 

[tusharm]

=c2+d2+time(10,0,0)

hi guys and girls

i have 2 formulas that i use regularly. I have a date in column c and a time in column d which i combine =c2+d2

simple works well. Problem it;s in gmt so a dd 10 hours for sydney time. Let say the result for the 1st formula is in h2, so i use

=h2+time(10,0,0), gives me sydney date and time. All good. Is the a way to combine this so as it does it all at once?

Cheers thanks in advance.

 

[frazzle6]

Thanks, that will save me time.
Cheers

 

[tusharm]

You are welcome.

Thanks, that will save me time.
Cheers