In M12:
=J14-MOD(J1,1)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nolan Holloway" wrote:

Next part. I need to shift the cells
J1=Current time
J14=End time
In h:mm AM/PM format
The formula needs to be in cell M12

"Bernard Liengme" wrote:

With future time in A1, use =B1-MOD(NOW(),1) to find the time between then
and now. Might need to format the cell with [h]:mm
NOW returns the date and the time. Excel stores this info as a serial number
starting with 1/1/1900. Days are the integer part, while time is the
fractional part; MOD(x,1) returns the fractional part of x.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Nolan Holloway" wrote in message
...
I want to use the now function to calculate elasped time. For example, I
leave work at 3:45pm Using the now function, what is the difference
between
the current time and when I have to leave?