[program-l] Excel....

  • From: "Corbett, James" <James.Corbett@xxxxxxxxxxxxx>
  • To: <program-l@xxxxxxxxxxxxx>
  • Date: Tue, 24 Mar 2009 08:16:31 -0400

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

Other related posts: