[access-uk] Re: AN EXCEL FORMULA PROBLEM
- From: "Mark Threadgold" <m.j.threadgold@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Mon, 1 Feb 2010 15:36:43 -0000
Assuming you use the 24 hour clock it is simply a matter of subtracting the
start time from the end time to detrimin how many hours worked.
In E9 you would put;
=(d9-c9)
If you try and use the 12 hour clock with am and pm then I have no idea what
horrible contortions you would need to go through to try and work it out.
Mark Threadgold
Of all the things I have ever lost, The one I miss most is my mind...
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
Carol Pearson
Sent: 01 February 2010 15:28
To: Access UK Mailing List
Subject: [access-uk] AN EXCEL FORMULA PROBLEM
Hi all,
Can anyone tell me what to write as my formula, please!
I have an employee who (for example) on a particular day starts work at 10
AM and works through to 2 PM so Start Time is in column C9 and End Time in
D9, with the result of hours in E9.
I've looked at HELP and still can't get the formula right.
Any help most welcome. Thanks!
--
Carol
carol.pearson29@xxxxxxxxxxxxxx
On Twitter: http://twitter.com/songbird49a
** 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
Other related posts:
