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