[program-l] Re: Excel....
- From: "Travis Roth" <travis@xxxxxxxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Mar 2009 08:01:37 -0500
Hi Jim,
According to http://www.cpearson.com/excel/datearith.htm
It says:
You can determine the number of hours and minutes between two times by
subtracting the two times. However, since Excel cannot handle negative
times, you
must use an =IF statement to adjust the time accordingly. If your times
were entered without a date (e.g, 22:30), the following statement will
compute
the interval between two times in A1 and B1 .
=IF(A1>B1,B1+1-A1,B1-A1)
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Corbett, James
Sent: Tuesday, March 24, 2009 7:17 AM
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Excel....
Ok, yet another question on this evolving project....
Lets say in cell A1 thru E1 I sum the value as previously suggested and
subtract 37.5 in order to display the number of straight hours of OT
worked....
Ok, works nice but now I want to be able to in a single cell enter the start
and end time, and calculate the actual amount of hours worked in that
day....
How would I go about this?
Jim
James M. Corbett
A / Technical Specialist
GST/HST Micros | Micros de la TPS/TVH
GST/HST Redesign Division | Division de la restructuration de la TPS/TVH
Revenue and Accounting Systems Directorate (RASD) | Direction des Systèmes
de revenu et de comptabilité (DSRC)
Information Technology Branch (ITB) | Direction générale de l'informatique
(DGI)
Canada Revenue Agency | Agence du revenue du Canada
(613) 941-1338
"...Is a hippopotamus a hippopotamus, or just a really cool Opotamus?"
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
