Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Days Elasped | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Calculating Elasped Time | Excel Discussion (Misc queries) | |||
Calculate elasped time | Excel Discussion (Misc queries) | |||
How do I calculate charges based on elasped time(H:MM) & rate($)? | Excel Discussion (Misc queries) |