S
Sam Ritchie
Please help....need a formula to add total time taken from cells containing time values from another formula.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Beamish
Please be a bit more specific.
Which column(s) contain data?
Which column(s) contain a formula (and what is the formula)?
What do you want to see in the "final total".
A few specific numbers would be helpful, too.
JLB, PMP
Which column(s) contain data?
Which column(s) contain a formula (and what is the formula)?
What do you want to see in the "final total".
A few specific numbers would be helpful, too.
JLB, PMP
containing time values from another formula.Sam Ritchie said:Please help....need a formula to add total time taken from cells
S
Sam Ritchie
JLB,
In column C, I have Time In, Column D, Time Out, In Column E, time incurred (D minus C), using the formula =text(d4-d3,"h:mm) ...I am looking for a formula to add all of column E. I.E. Column C 9:00, Column D 10:20, Column E (with the text formula) showing 1:20. Looking to add rows in column E and arrived at a total also in the time format. Many thanks.
----- John Beamish wrote: -----
Please be a bit more specific.
Which column(s) contain data?
Which column(s) contain a formula (and what is the formula)?
What do you want to see in the "final total".
A few specific numbers would be helpful, too.
JLB, PMP
In column C, I have Time In, Column D, Time Out, In Column E, time incurred (D minus C), using the formula =text(d4-d3,"h:mm) ...I am looking for a formula to add all of column E. I.E. Column C 9:00, Column D 10:20, Column E (with the text formula) showing 1:20. Looking to add rows in column E and arrived at a total also in the time format. Many thanks.
----- John Beamish wrote: -----
Please be a bit more specific.
Which column(s) contain data?
Which column(s) contain a formula (and what is the formula)?
What do you want to see in the "final total".
A few specific numbers would be helpful, too.
JLB, PMP
containing time values from another formula.Sam Ritchie said:Please help....need a formula to add total time taken from cells
J
John Beamish
Sam
I'm still having a bit of difficulty understanding your situation. Here's
what I understand so far:
In Project you are showing:
A. Start (showing date and time),
B. Finish (showing date and time),
C. "Time In" (I presume this is a renamed field. What field was it before
it was renamed? If you aren't sure, then doubleclick the column header and
the pop-up dialog box will tell you the original Field Name)
D "Time Out" (Another renamed field. Please let me know what it was before
it was renamed)
E "Time Incurred" (Another renamed field. Please let me know what it was
before it was renamed)
With those final pieces of information, I am confident that I can give you
the necessary formula.
for a formula to add all of column E. I.E. Column C 9:00, Column D 10:20,
Column E (with the text formula) showing 1:20. Looking to add rows in
column E and arrived at a total also in the time format. Many thanks.
I'm still having a bit of difficulty understanding your situation. Here's
what I understand so far:
In Project you are showing:
A. Start (showing date and time),
B. Finish (showing date and time),
C. "Time In" (I presume this is a renamed field. What field was it before
it was renamed? If you aren't sure, then doubleclick the column header and
the pop-up dialog box will tell you the original Field Name)
D "Time Out" (Another renamed field. Please let me know what it was before
it was renamed)
E "Time Incurred" (Another renamed field. Please let me know what it was
before it was renamed)
With those final pieces of information, I am confident that I can give you
the necessary formula.
incurred (D minus C), using the formula =text(d4-d3,"h:mm) ...I am lookingSam Ritchie said:JLB,
In column C, I have Time In, Column D, Time Out, In Column E, time
for a formula to add all of column E. I.E. Column C 9:00, Column D 10:20,
Column E (with the text formula) showing 1:20. Looking to add rows in
column E and arrived at a total also in the time format. Many thanks.
S
Sam Ritchie
JLB,
Sorry, I was out of the country on a business trip. At any rate, not quite sure what you mean by heading.
Anyhow, both the time in and time out are in time format, i.e. 09:30 (if you click on this, the formula heading
on top shows 9:30:00 AM). Let me show you the complete scenario.....
Row 1 Time In (under column A), Time out (under column B), Time Incurred (under column C).
Row 2 09:30 (under column A), 10:30 (under column B), 1:30 (under column C). Column C has a formula
which is =text(b2-a2,"h:mm").
Problem - unable to come up with a formula to add all of column c as more rows are added.
Thanks
Sorry, I was out of the country on a business trip. At any rate, not quite sure what you mean by heading.
Anyhow, both the time in and time out are in time format, i.e. 09:30 (if you click on this, the formula heading
on top shows 9:30:00 AM). Let me show you the complete scenario.....
Row 1 Time In (under column A), Time out (under column B), Time Incurred (under column C).
Row 2 09:30 (under column A), 10:30 (under column B), 1:30 (under column C). Column C has a formula
which is =text(b2-a2,"h:mm").
Problem - unable to come up with a formula to add all of column c as more rows are added.
Thanks
D
Dale Howard
Sam --
It sounds like you are working in Microsoft Excel rather than Microsoft
Project. Is this the case? Your references to columns A, B, C, etc. sound
like an Excel spreadsheet rather than a Microsoft Project plan. If this is
the case, you should post your question in one of the Excel newsgroups such
as:
microsoft.public.excel
Let us know, as I am as thoroughly confused by your questions as JLB is.
Thanks!
It sounds like you are working in Microsoft Excel rather than Microsoft
Project. Is this the case? Your references to columns A, B, C, etc. sound
like an Excel spreadsheet rather than a Microsoft Project plan. If this is
the case, you should post your question in one of the Excel newsgroups such
as:
microsoft.public.excel
Let us know, as I am as thoroughly confused by your questions as JLB is.
Thanks!
quite sure what you mean by heading.Sam Ritchie said:JLB,
Sorry, I was out of the country on a business trip. At any rate, not
you click on this, the formula headingAnyhow, both the time in and time out are in time format, i.e. 09:30 (if
J
John Beamish
As Dale says, this seems like you're working in Excel.
(Hope the business trip was successful ... and did you bring me back a
present?)
--
(Hope the business trip was successful ... and did you bring me back a
present?)
JLB,
Sorry, I was out of the country on a business trip. At any rate, not
quite sure what you mean by heading.
Anyhow, both the time in and time out are in time format, i.e. 09:30 (if
you click on this, the formula heading
on top shows 9:30:00 AM). Let me show you the complete scenario.....
Row 1 Time In (under column A), Time out (under column B), Time
Incurred (under column C).
Row 2 09:30 (under column A), 10:30 (under column B), 1:30 (under
column C). Column C has a formula
which is =text(b2-a2,"h:mm").
Problem - unable to come up with a formula to add all of column c as
more rows are added.
Thanks
--