Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Albert Delamo Jobclock Name: Cora Date Range: 10/11/2004 Through 10/17/2004 Start End Activity 10/14/2004 7:22:22 AM 10/14/2004 4:34:34 PM 9.20 0.75 8.45 10/15/2004 7:10:32 AM 10/15/2004 2:57:46 PM 7.79 0.75 7.04 (total unde this last figure) Jobclock subtotal: 16.99 hours 15.49 Jobclock Name: pasta Date Range: 10/11/2004 through 10/17/2004 Start End Activity 10/11/2004 7:09:02 AM 10/11/2004 5:39:02 PM 10.50 0.75 9.75 10/12/2004 7:22:28 AM 10/12/2004 5:10:42 PM 9.80 0.75 9.05 (total unde this last figure) Jobclock subtotal: 30.35(incorrect)hours Employee subtotal: 47.34(incorrect)hours $12.00 $411.48 this (if it comes out ok) is what the spreadsheet looks like. there i usually 1-3 rows between each item. ill have to play with the subtotal feature. vba is a little diffrent than vb and im a bit of a n00b when i come to vb so... thank you for the help -- onesain ----------------------------------------------------------------------- onesaint's Profile: http://www.excelforum.com/member.php...nfo&userid=937 View this thread: http://www.excelforum.com/showthread.php?threadid=27095 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlight a Cell if Data not Present | Excel Discussion (Misc queries) | |||
Auto Insert the present time when a cell is filled with a data, | New Users to Excel | |||
Returning an empty cell when no data present | Excel Discussion (Misc queries) | |||
auto sum macro if data is present above the cell | Excel Programming | |||
Coloring Cell if Data is present | Excel Programming |