time formulate
:) thanks, Domenic...
"Domenic":
For the total hours in the last 7 days, try...
=SUMPRODUCT(--(SUBSTITUTE(A2:A5,".","/")+0TODAY()-7),B2:B5)
....and format the cell as follows...
Format Cells Number Custom Type: [h]:mm
If you change the format so that Column A contains true dates, for
example...
12/20/05
4/11/06
4/25/06
4/15/06
....you could use the following formula instead...
=SUMPRODUCT(--(A2:A5TODAY()-7),B2:B5)
Hope this helps!
In article ,
arslan wrote:
correction for my problem...
A B C D
E
1 date working hours work.hors yor work.hours for work.hours
last 7 days last 30 days
for last year
2 12.20.05 08:15
3 01.01.06 08:00
4 03.25.06 07:55
5 04.15.06 08:45
How can i formulate each cell on column C,D, and E?
|