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
>
>
Bookmarks