how do calculate elasped time
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? |
how do calculate elasped time
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? |
how do calculate elasped time
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? |
how do calculate elasped time
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? |
All times are GMT +1. The time now is 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com