| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using two cells 1 with total time n 1 with date how can i put the.
I'm trying to put the amount of time spent in to a seperate sheet (Cell # 2
column E ) from a sheet that has the dates in one cell (column A) and the time spent in another (column K) and the reason for the time spent in column B. On the seperate sheet I have to put the amount of time spent in column E and match with the date I have in column A on the seperate sheet to populate the chart that I'm making. The only thing that I have been able to do is create a formula to show the amount of time spent and for what reason but i can't match it to the date because the dates can come in mulitiples of the same date. Please help!!! It's for my job |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| totaling time in 2 cells w/ total of hours worked in 3rd | Excel Discussion (Misc queries) | |||
| Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y | Excel Discussion (Misc queries) | |||
| How do I get total hours from 2 date/time cells? | Excel Discussion (Misc queries) | |||
| Grand total time between two total cells | Excel Discussion (Misc queries) | |||
| Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
Threaded Mode
