How do I create multiple time zones by using the NOW formula?

Question

I'm trying to create 5 cells with different time zones: CDT MDT MST PDT EDT

I am in MST, so I obviously get my current time by doing

NOW()

How do I add hours to that? I tried

NOW()+(2,0,0)

But all I got was an error. I also got errors when I tried

A1 + (2,0,0) and A1 *(2,0,0)

Is there a simple solution to this?

Answer 1

• to add +1 hour: =NOW()+(1/24)

• to add -2 hours:

• more examples:

Answer 2

I found a simple answer, just do the =now()function and then format the cell lol, it worked for me :) https://www.excelhow.net/how-to-convert-time-format-from-12-hour-clock-to-24-or-24-to-12-hour-clock-in-excel.html