| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating daily hours (as text) in the weekly total formula
I am baffled as to how to get my spreadsheet to recognize the daily
totals and accumulate to equal weekly hours... i.e. COLUMN 1: 7:45 AM COLUMN 2: 6:00 PM COLUMN 3 (SUM OF ROW 1 & 2) AND IT PROGRESSES THROUGH THE WEEK, BUT WHEN I TRY TO GET MY TOTALS COLUMN TO READ COLUMN 3. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating daily hours (as text) in the weekly total formula
7:45 AM in A1, 6:00 PM in B1, =B1-A1 in C1 gives 10:15 if you format the
result as [h]:mm, and if you keep that format in column C you can total the numbers for the week. -- David Biddulph "CNBCheryl" wrote in message ... I am baffled as to how to get my spreadsheet to recognize the daily totals and accumulate to equal weekly hours... i.e. COLUMN 1: 7:45 AM COLUMN 2: 6:00 PM COLUMN 3 (SUM OF ROW 1 & 2) AND IT PROGRESSES THROUGH THE WEEK, BUT WHEN I TRY TO GET MY TOTALS COLUMN TO READ COLUMN 3. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working Hours (formula & graph) - any elegant solution? | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Formula used to calculate daily employment hours ... | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Problems calculating total hours | Excel Discussion (Misc queries) | |||
Linear Mode
