visual basic for applications. You'd have to script the solution with vba. HTH Johannes -----Original Message----- From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx] On Behalf Of Corbett, James Sent: Tuesday, March 24, 2009 3:25 PM To: program-l@xxxxxxxxxxxxx Subject: [program-l] Re: Excel.... Travis: I would really like to have the start and end values in a single cell, any ideas? Jim -----Original Message----- From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx] On Behalf Of Travis Roth Sent: March 24, 2009 09:02 To: program-l@xxxxxxxxxxxxx Subject: [program-l] Re: Excel.... 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 ** 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