Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates and hours
I am needing to calculate the hours (with decimal portion) between two times
spanning two or more dates e.g. the time between 2/4/2007 3:00 am 2/5/2007 7:45 pm and have it displayed as a decimal portion of a 24 hour day I have tried several formulas - no dice.... Thanks in advance for any help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates and hours
=(B1-A1)*24
format cell as general "goldenrod59" wrote: I am needing to calculate the hours (with decimal portion) between two times spanning two or more dates e.g. the time between 2/4/2007 3:00 am 2/5/2007 7:45 pm and have it displayed as a decimal portion of a 24 hour day I have tried several formulas - no dice.... Thanks in advance for any help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates and hours
I experimented with 2/4/2007 3:00 am and 2/5/2007 7:45 pm and I got 16.75.
I also experimented with 2/4/2007 3:00 am and 2/7/2007 7:45 pm and I got 64.75. Sounds about right? See if this helps. http://www.cpearson.com/excel/datearith.htm Scroll down. Do you have date and time in one cell or date in one cell and time in a different cell? Epinn "goldenrod59" wrote in message ... I am needing to calculate the hours (with decimal portion) between two times spanning two or more dates e.g. the time between 2/4/2007 3:00 am 2/5/2007 7:45 pm and have it displayed as a decimal portion of a 24 hour day I have tried several formulas - no dice.... Thanks in advance for any help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates and hours
I tried this formula - inserting the cell ID's where my input dates were.
When I placed in in the cell adjacent to the two inputs - it worked. Earlier - I had the exact same formula - however when it was several cells to the right - it would not calculate I tried moving the formula to the right - keeping the inputs the same - and it would not calculate. But this formula works Thanks "Teethless mama" wrote: =(B1-A1)*24 format cell as general "goldenrod59" wrote: I am needing to calculate the hours (with decimal portion) between two times spanning two or more dates e.g. the time between 2/4/2007 3:00 am 2/5/2007 7:45 pm and have it displayed as a decimal portion of a 24 hour day I have tried several formulas - no dice.... Thanks in advance for any help |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with dates and hours
If you want help, you will need to explain what "would not calculate" means.
What results did you get? What did you expect? What formula did you use? -- Regards, Fred "goldenrod59" wrote in message ... I tried this formula - inserting the cell ID's where my input dates were. When I placed in in the cell adjacent to the two inputs - it worked. Earlier - I had the exact same formula - however when it was several cells to the right - it would not calculate I tried moving the formula to the right - keeping the inputs the same - and it would not calculate. But this formula works Thanks "Teethless mama" wrote: =(B1-A1)*24 format cell as general "goldenrod59" wrote: I am needing to calculate the hours (with decimal portion) between two times spanning two or more dates e.g. the time between 2/4/2007 3:00 am 2/5/2007 7:45 pm and have it displayed as a decimal portion of a 24 hour day I have tried several formulas - no dice.... Thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating time increments from dates during working hours | Excel Worksheet Functions | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
how to calulate time in hours cbetween two different dates? | Excel Worksheet Functions | |||
Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions |