Kingwood Underground
the heart and soul of our Kingwood, Texas family
Login - Create Account - Help
Clean out your garage on Kingwood bookoo! Or find local garage sales on Yard Sale Search.com
KU Live!

Attn Excel guru

who's talking here?

Sandyr9111 3
MunchkinMinder 2
wyfe4lyfe 5
Fin and Feather 6

     » send to friend     » save in my favorites     » flag dangerous topic flag as a dangerous topic

Fin and Feather --- 18 years ago -

If I have a time /date in the same cell how can you find a diff? a1= 1/5/2008 15:00 b1= 1/5/2008 21:00 We did simple =a1-B1, but it is not right  

Fin and Feather --- 18 years ago -

I know you have to convert into long form # first, but what formula would you use? 

MunchkinMinder --- 18 years ago -

you have to put =difference(a1:b1) or =(a1-b1) 

MunchkinMinder --- 18 years ago -

i'm not postivive cause its been a while but i'm pretty sure thats it or something like that and i'm not sure if it'll do it with time 

Fin and Feather --- 18 years ago -

We did this however some look correct at first but others are like 4.89, then I realized that we are not going time to time. Last # should never be over 60. I used to do the all the time but that was 7+ years ago. 

wyfe4lyfe --- 18 years ago -

Try this... =round(24*(b1-a1),2) The above will get you hours difference 

Sandyr9111 --- 18 years ago -

Where is Sandface? 

Sandyr9111 --- 18 years ago -

Where is Sandface? 

Sandyr9111 --- 18 years ago -

Where is Sandface? 

wyfe4lyfe --- 18 years ago -

or... b1-a1 then change your format of the cell to [h]:mm:ss 

wyfe4lyfe --- 18 years ago -

or... this one is pretty cool =DATEDIF(A1,B1 -(MOD(A1,1)>MOD(B1,1)),"y")&" years, "&DATEDIF(A1,B1 -(MOD(A1,1)>MOD(B1,1)),"ym")&" months, "&DATEDIF(A1,B1 -(MOD(A1,1)>MOD(B1,1)),"md")&" days, "&TEXT(MOD(B1-A1,1),"hh "" hours, and "" mm "" minutes""") 

Fin and Feather --- 18 years ago -

2nd one worked, Now that we have a difference in times, why will the column not add? 

wyfe4lyfe --- 18 years ago -

I'm not sure what you mean? What are you trying to add? 

Fin and Feather --- 18 years ago -

We now have the difference in times in column c, now how can you add total, mine will not sum up, and when it does the total is less than 1/8th of what it should be 

Fin and Feather --- 18 years ago -

Mm it was a little deeper, stinking format problem thanks All fixed, thanks to wyfe4lyfe 

wyfe4lyfe --- 18 years ago -

It was no problem. Glad I could help :) 

page 1
Login to add your comments!

see more discussions about...


Online now:
hit counters

Terms of Service - Privacy Policy - Ice Box

Kingwood Underground