Subtract 7:00 pm from 7:30 pm
This is easy. First aquaint yourself with time and date
format. the important concept here is even if you wish to only display 7:30 AM the cell will also have the date (8/21/03) information in it. So if you ask for a hh:mm display the cell will actually have [mm/dd/yy and} hh:mm. So format cell A1 for hh:mm and plug in 7:00. Then format A2 and A3 using Format Painter. Plug 7:30 into A2. Now in A3 Subtract A1 from A2 [=A2-A1] Want to know how many days sice you were born? enter =TODAY () into cell B1, the format paint B1 into B2 Enter your birthdate into B2. Don't format B3 now =B2-B1 Result is number of days -----Original Message----- Hope someone can help... I need to get the difference between two times ie: End - Start. I guess I need a formula that I can use in Excel that will allow me to enter the start time, the end time, and then in another cell, get the difference. So, If I start a job at 7:00 PM (Which is how I enter the info in the cell) and end the job at say 9:45 PM (entered in the second cell) the third cell will display 2 Hr 45 min. I think I am explaining this badly... I guess what I need is to be able to perform math (Add/Subtract) on Time. I am not familiar with how Excel uses Time Values. Begin End Total 7:00 PM 7:30 PM 30 min Hope someone can help Larry . |
All times are GMT +1. The time now is 02:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com