Automatic Time Update as per Timezone

Silkaline

New member
Joined
Aug 25, 2017
Messages
4
Reaction score
0
Points
0
Location
Kathmandu, Nepal
Excel Version(s)
2010
Hi,
I need Help on making formula to automatic time update to different timezone. I have attached file. Any help would be greatly appreciated.

Thank You.
 

Attachments

  • Timezone.xlsx
    9.5 KB · Views: 23
Try:

=B2+C2-TIME(5,75,)-TIME(4,,
) for EST
=B2+C2-TIME(5,75,)-TIME(7,,) for PST
 
Thank you very much for reply. I think something went wrong. When I used this formula EST and PST are not showing correct time. I have attached the updated one with this formula...
 

Attachments

  • Timezone.xlsx
    9.9 KB · Views: 15
Sorry, my the MINUTE parameter in my formula should have been 45, not 75.

=B2+C2-TIME(5,45,)-TIME(4,,) for EST
=B2+C2-TIME(5,45,)-TIME(7,,) for PST
 
Hi NBVC

Can you please explain why you used B2 as its a date?

Regards
Sahil
Because I need to combine date and time to subtract an amount of time which could end up being previous day.
 
Back
Top