| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I format cells and enter data to be valued for TIME and th.
I need to calculate the difference between 2 or 3 times. Example: Start 9am,
Finish 6pm - how do i format the cells, enter the data in the cells and calculate the difference to give me a result in time? |
|
#2
|
|||
|
|||
|
2
Enter time as 9:00 AM and 6:00 pm in say B2 and c2 and use the formula =b2-c2-0.041667. this assumes a one hour lunch break Same fomula works for time entered in 24 hour format. e.g. 9:00 and 18:00 regards Peter "George" wrote: I need to calculate the difference between 2 or 3 times. Example: Start 9am, Finish 6pm - how do i format the cells, enter the data in the cells and calculate the difference to give me a result in time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I move cells after data input without using enter or tab | Excel Discussion (Misc queries) | |||
| Excel - cursor moves to other cells after I enter data, without h. | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
| Dates in 2005 format cells are not entering correctly. | Excel Worksheet Functions | |||
| How can I keep a cells format, general, from changing after enter. | Excel Discussion (Misc queries) | |||
Linear Mode
