The NOW() function returns the serialized date and time. The date is left of the
decimal, the time  is right of the decimal. Format a cell as general, then enter
=NOW() in the cell and you will see the numbers. Perhaps this will give you what
you need.