time now
Hi Miguel
That was just what I was after.
Many thanks
Lee
"Miguel Zapico" wrote:
You can also try this one:
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))
The data that you get is the same as with the other solutions, but this
comes directly formated as required:
"Lee Crew" wrote:
Hi Pete
this returns the follwoing
00/01/1900 13:19
is there any way of it just returning 13:19
Many Thanks
Lee
"Pete_UK" wrote:
Instead of using NOW() in a cell, replace it with MOD(NOW(),1)
Alternatively, if you have the NOW() formula in A1, then in B1
=A1 - INT(A1)
Format as time.
Hope this helps.
Pete
|