You realize that NOW() will update whenever the sheet is calculated, so if
the user type in a type eventually that time will be less than NOW()). If
you want to subtract 2 times and start time has a date and end does not you
can use

=B1-MOD(A1,1)

start time and date in A1 and end time in B1

--
Regards,

Peo Sjoblom

(No private emails please)


"canix" wrote in
message ...

tobriant Wrote:
You can format the cells as custom (e.g., m/d/yyyy h:mm AM/PM) have the
user enter data as 8/5/2005 9:05. This will store as 8/5/2005 9:05 AM.
Have the output cell set as custom hh:mm:ss.

But that would be too much for user who had to enter the date and time
altogether. Is there anyway that can perform automatically where user
only need to enter the time.


--
canix
------------------------------------------------------------------------
canix's Profile:
http://www.excelforum.com/member.php...o&userid=25962
View this thread: http://www.excelforum.com/showthread...hreadid=393333