Yeah, someone else gave me that one but so far I just haven't got it to work and I really don't know why.
I'll try a blank sheet instead of working on current data so that I can be sure to format all cells accordingly and see what happens.
Thanks.It's not a really big deal to write in those figures but just unnecessary ... and I like to be tidy! <Smiles>
Thanks for your input. -- Carol carol.pearson29@xxxxxxxxxxxxxx On Twitter: http://twitter.com/songbird49a ---- Original Message ---- From: "Mike Moore" <mikeis@xxxxxxxxxxxxxx> To: <access-uk@xxxxxxxxxxxxx> Sent: Tuesday, February 02, 2010 3:34 PM Subject: [access-uk] Re: AN EXCEL FORMULA PROBLEM
Carol, I tried this: Highlight all cells which are to include time data, including where your formulae is going. Set to time in the format cells section. If for example the time in cell a1 is 09:05 and b1 is 15:10 then the result in c1 would be: =B1-a1 which gives the difference. I hope this is of help. Regards, Mike ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
