Help with identifying time and time zones in a formula
=Q278&" "&TEXT(J278,"hh:mm")&" CST "&N278&", "&P278&" SAB"
I have the above formula in column M where column J will be entered the current time. I need the time to be equivalent to Eastern Standard Time rather than Central as it displays when I use Ctrl+SHIFT+; Can anyone suggest how I would add an hour to the display of the time I enter with the above shortcuts? Thanks |
Help with identifying time and time zones in a formula
To add one hour more use the TIME() function and + operator
=Q278&" "&TEXT(J278+TIME(1,0,0),"hh:mm")&" CST "&N278&", "&P278&" SAB" If this post helps click Yes --------------- Jacob Skaria "Mr BT" wrote: =Q278&" "&TEXT(J278,"hh:mm")&" CST "&N278&", "&P278&" SAB" I have the above formula in column M where column J will be entered the current time. I need the time to be equivalent to Eastern Standard Time rather than Central as it displays when I use Ctrl+SHIFT+; Can anyone suggest how I would add an hour to the display of the time I enter with the above shortcuts? Thanks |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com