Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize total hours over multiple days
EXCEL 2003- How can I modify
"=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time in one cell and end time in another cell. And how do I link those cells to a date. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize total hours over multiple days
Do the cell have data like:
A) 10:30 PM or B) 9/1/2008 3:30 PM best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DavidT" wrote in message ... EXCEL 2003- How can I modify "=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time in one cell and end time in another cell. And how do I link those cells to a date. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize total hours over multiple days
Let
A1 has date such a 9/1/2008 (US style) A2 has time such as 3:30 PM And this two values represent start time B1 has date such as 9/3/2008 B2 has time such a 7:00 AM And this two values represent end time The =((B1+B2)-(A1+A2))*24 gives 39.5 when formatted General as 39 1/2 hours have passed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DavidT" wrote in message ... EXCEL 2003- How can I modify "=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time in one cell and end time in another cell. And how do I link those cells to a date. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize total hours over multiple days
I have one column with consecutive dates(ie.A1,A2,A3...), the next column
with a start time(ie.B1) adjacent to that date, the next column with the stop time(ie.D3) adjacent to an ensuing date(ie.A3), and the next column for the total hours from B1 to D3. A B C D Date Start Stop Total 1 1/1 10:00 2 1/2 3 1/3 8:00 from B1 to C3 What is needed is a formula to show total hours and minutes from start to stop. "Bernard Liengme" wrote: Do the cell have data like: A) 10:30 PM or B) 9/1/2008 3:30 PM best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DavidT" wrote in message ... EXCEL 2003- How can I modify "=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time in one cell and end time in another cell. And how do I link those cells to a date. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize total hours over multiple days
That solution won't work as I need to have a running calender in a single
column and the ability to enter start time in one col. adj to one date and an end time adj to an ensuing date with a solution in the next col. I need to make multiple entries of start/stop times through the calender month. "Bernard Liengme" wrote: Let A1 has date such a 9/1/2008 (US style) A2 has time such as 3:30 PM And this two values represent start time B1 has date such as 9/3/2008 B2 has time such a 7:00 AM And this two values represent end time The =((B1+B2)-(A1+A2))*24 gives 39.5 when formatted General as 39 1/2 hours have passed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DavidT" wrote in message ... EXCEL 2003- How can I modify "=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time in one cell and end time in another cell. And how do I link those cells to a date. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize total hours over multiple days
Hi,
Assume your data starts in A1:C4 where row 1 contains titles then: =A4+C4-A2-B2 Format this cell as Custom [hh]:mm If this helps, please click the Yes button. -- Thanks, Shane Devenshire "DavidT" wrote: That solution won't work as I need to have a running calender in a single column and the ability to enter start time in one col. adj to one date and an end time adj to an ensuing date with a solution in the next col. I need to make multiple entries of start/stop times through the calender month. "Bernard Liengme" wrote: Let A1 has date such a 9/1/2008 (US style) A2 has time such as 3:30 PM And this two values represent start time B1 has date such as 9/3/2008 B2 has time such a 7:00 AM And this two values represent end time The =((B1+B2)-(A1+A2))*24 gives 39.5 when formatted General as 39 1/2 hours have passed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DavidT" wrote in message ... EXCEL 2003- How can I modify "=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time in one cell and end time in another cell. And how do I link those cells to a date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
Running total of hours based on last 7 days | Excel Worksheet Functions | |||
How do I summarize time that exceeds 24 hours? | Excel Worksheet Functions | |||
Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions |