Current CST time formula

[shiva_reshs]

Hello,

I know the formula to show system time. I.e

Please Login or Register  to view this content.

Any ways I can add minus 11.50 hours in it, so it can show CST time?

Thanks,
Shiva

[Jonmo1]

Try

=NOW()-"11:30:00"

[JieJenn]

Maybe

=NOW()-TIME(11,30,0)

[Pete_UK]

Try this:

=MOD(NOW()-TIME(11,30,0),1)

Format as a time in the style that you prefer.

Hope this helps.

Pete

[shiva_reshs]

=MOD(NOW()-TIME(11,30,0),1) = This give me 01/0/1900 11.01


=NOW()-"11:30:00" and =NOW()-TIME(11,30,0) , these works, But everyday if i use the same formula on another cell. Time of this also changes..

Any ways one it is entered, we make it not to change on entering in different cell?

Thanks for quick response though.

[Pete_UK]

You didn't format the cell to show the time only with my formula.

NOW is a volatile formula - it will always recalculate to show the correct time at that instant. If you want a timestamp then you can use CTRL; in a cell to get the date, and CTRL: to get the time.

Hope this helps.

Pete

[Jonmo1]

After entering the formula you want, you can copy it and then Paste Special - Values

[shiva_reshs]

hmm.. Thanks..

Will use the paste special value.