IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Open Forum / Add days for when logout is next day.
Post #185,726
by jbrabeck
12/1/04 2:38:13 PM
Reply
New Add days for when logout is next day.
A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!"
Post #185,745
by andread
12/1/04 4:53:40 PM
Reply
New Re: Add days for when logout is next day.
with answer cell formatted general

you could use the int function
with
a1 12/1/04 12:20
b1 1/4/05 13:10
formula
=int((b1-a1)*24)
would give you 816 (hours)

if you needed more accuracy you could use
=((b1-a1)*1440)/60
which gives 816.8333

plain =b1-a1
gives a result of 34.03472222 (days)

A

Play I Some Music w/ Papa Andy
Saturday 8 PM - 11 PM ET
All Night Rewind 11 PM - 5 PM
Reggae, African and Caribbean Music
[link|http://wxxe.org|Tune In]
     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

Is you stupid, or is you just high?
34 ms