2

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?

2 Answers 2

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

0

  • to add -2 hours:

0

  • more examples:

0

4
  • That is exactly what I needed. Thank you! How do I make it so that I just see the hour and not the date? Also is there a way that I can do 12hr time instead of military time? May 3, 2019 at 14:52
  • @TylerGarver answer updated
    – user0
    May 3, 2019 at 15:03
  • =TEXT(NOW()+(1/24), "h:mm:ss am/pm")
    – user0
    May 3, 2019 at 15:03
  • PSA to other readers with similar questions: Sheets does not actually handle time zones natively—the above naturally depends utterly on your math. Second, if these TZ conversions are mission-critical, note that for the few hours twice a year in which Daylight- and Standard- changes sweep across the zones, they stop having those static offsets. Or your situation may differ further—some zones don't change, some have odd changes, your worldwide offsets could even be wrong half the year. Anything tricky? Use Apps Script! Fun video on problems.
    – Joel Reid
    May 3, 2019 at 17:43
-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

1
  • Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.
    – Community Bot
    Feb 7 at 7:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.