LinkBack URL
About LinkBacks
Hello,
I know the formula to show system time. I.eAny ways I can add minus 11.50 hours in it, so it can show CST time?
=Now()
Thanks,
Shiva
Hello,
I know the formula to show system time. I.eAny ways I can add minus 11.50 hours in it, so it can show CST time?=Now()
Thanks,
Shiva
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Try
=NOW()-"11:30:00"
Maybe
=NOW()-TIME(11,30,0)
Try this:
=MOD(NOW()-TIME(11,30,0),1)
Format as a time in the style that you prefer.
Hope this helps.
Pete
=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.
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
After entering the formula you want, you can copy it and then Paste Special - Values
hmm.. Thanks..
Will use the paste special value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks