Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate time durations over numerous dates
I am trying to enter data that was collected on different dates/times and
calculate the duration of the entire data collection. How can I enter the dates and time such that I can calculate the duration? I am using Excel 2000 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate time durations over numerous dates
If you enter them as standard time, such as 09:15:30, then just subtract
them to get the duration, and format that as time also. -- HTH RP (remove nothere from the email address if mailing direct) "MBubier" wrote in message ... I am trying to enter data that was collected on different dates/times and calculate the duration of the entire data collection. How can I enter the dates and time such that I can calculate the duration? I am using Excel 2000 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate time durations over numerous dates
I've got that, but what about including different dates? I tried formatting
the cell such that the date is also part of the entry but then I can not subtract them. "Bob Phillips" wrote: If you enter them as standard time, such as 09:15:30, then just subtract them to get the duration, and format that as time also. -- HTH RP (remove nothere from the email address if mailing direct) "MBubier" wrote in message ... I am trying to enter data that was collected on different dates/times and calculate the duration of the entire data collection. How can I enter the dates and time such that I can calculate the duration? I am using Excel 2000 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate time durations over numerous dates
Why not? It will still have a valid value, it just differs how you present
it. One way would be =INT(A2-A1)&" days, "&TEXT(MOD(A2-A1,1),"hh:mm:ss") -- HTH RP (remove nothere from the email address if mailing direct) "MBubier" wrote in message ... I've got that, but what about including different dates? I tried formatting the cell such that the date is also part of the entry but then I can not subtract them. "Bob Phillips" wrote: If you enter them as standard time, such as 09:15:30, then just subtract them to get the duration, and format that as time also. -- HTH RP (remove nothere from the email address if mailing direct) "MBubier" wrote in message ... I am trying to enter data that was collected on different dates/times and calculate the duration of the entire data collection. How can I enter the dates and time such that I can calculate the duration? I am using Excel 2000 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate time durations over numerous dates
Format the result as Custom [h]:mm otherwise the sum will "tip over" each
24 hrs -- Kind regards, Niek Otten "Bob Phillips" wrote in message ... Why not? It will still have a valid value, it just differs how you present it. One way would be =INT(A2-A1)&" days, "&TEXT(MOD(A2-A1,1),"hh:mm:ss") -- HTH RP (remove nothere from the email address if mailing direct) "MBubier" wrote in message ... I've got that, but what about including different dates? I tried formatting the cell such that the date is also part of the entry but then I can not subtract them. "Bob Phillips" wrote: If you enter them as standard time, such as 09:15:30, then just subtract them to get the duration, and format that as time also. -- HTH RP (remove nothere from the email address if mailing direct) "MBubier" wrote in message ... I am trying to enter data that was collected on different dates/times and calculate the duration of the entire data collection. How can I enter the dates and time such that I can calculate the duration? I am using Excel 2000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
How do I calculate and show negative time in Excel? | Excel Worksheet Functions | |||
Calculate time and cost | Excel Worksheet Functions | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) |