Returning the Time part from NOW()

[ElmerS]

Hi,

It is known that NOW() presents Date & Time.

Date as a whole number and Time as a decimal fracture.

In a sheet, the formula: =MOD(NOW(),1) returns 0.430956597 for 10:20 AM (which is OK).

When I try, this: T = Now Mod 1 (in VBA) T returns 'zero'.

Is there an educational explanation for this behavior ?

Thanks, Elm

[DonkeyOte]

In VBA use TIME statement.

Per the VBA Help files you will find MOD in VBA works with whole numbers.

[ElmerS]

Thank you.

I'm familar with TIME.

This was an "understandig" question as per the "strange behavior" of MOD in VBA.

Everything clear now.

Elm.