In 2002 I just subtract Login from Logout (En-Dn) and then format the output cell with a custom format d h:mm:ss - gives you DAYS HH:MM:SS
Should work.
Help with Excel
- (alvitale)
- (14)
- Dec. 1, 2004, 11:45:04 AM EST
Maybe use DATEVALUE and TIMEVALUE?
-NT
- (Another Scott)
- Dec. 1, 2004, 11:48:34 AM EST
Re: Help with Excel
- (andread)
- (11)
- Dec. 1, 2004, 02:27:45 PM EST
Add days for when logout is next day.
-NT
- (jbrabeck)
- (1)
- Dec. 1, 2004, 02:38:13 PM EST
Re: Add days for when logout is next day.
- (andread)
- Dec. 1, 2004, 04:53:40 PM EST
Re: Help with Excel
- (alvitale)
- (8)
- Dec. 2, 2004, 02:22:27 PM EST
Andy doesn't like that. ;-)
-NT
- (Another Scott)
- (7)
- Dec. 2, 2004, 03:00:10 PM EST
Re: Andy doesn't like that. ;-)
- (andread)
- (6)
- Dec. 2, 2004, 04:02:44 PM EST
Thank you, Andrea Dear, I'll remember that! ;^>
-NT
- (CRConrad)
- (5)
- Dec. 2, 2004, 06:44:37 PM EST
You're Welcome Charlene
-NT
- (andread)
- (4)
- Dec. 3, 2004, 11:58:08 AM EST
His welcome charlene what?
- (pwhysall)
- (1)
- Dec. 3, 2004, 08:02:03 AM EST
TGIF!
- (Another Scott)
- Dec. 3, 2004, 08:13:39 AM EST
Re: You're Welcome COMMA Charlene
- (pwhysall)
- (1)
- Dec. 3, 2004, 02:13:44 PM EST
C-h k C-,
- (Arkadiy)
- Dec. 3, 2004, 03:02:34 PM EST
What version Excel?
- (jbrabeck)
- Dec. 1, 2004, 02:37:11 PM EST