| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time Sheet calculations
Hi, I'm creating a time card that lists time in the 12 hour am-pm fomat. How do I calculate time between in and out (keeping in mind that there will be overnight shifts). Thanks- Donna -- dkostel ------------------------------------------------------------------------ dkostel's Profile: http://www.excelforum.com/member.php...o&userid=16794 View this thread: http://www.excelforum.com/showthread...hreadid=319903 |
|
#2
|
|||
|
|||
|
Take a look he
http://cpearson.com/excel/datetime.htm#AddingTimes In article , dkostel wrote: I'm creating a time card that lists time in the 12 hour am-pm fomat. How do I calculate time between in and out (keeping in mind that there will be overnight shifts). |
|
#3
|
|||
|
|||
|
If C contains the start time and D the finish time then place this in E
D3-C3+(D3 < C3) and format appropriately "dkostel" wrote in message ... Hi, I'm creating a time card that lists time in the 12 hour am-pm fomat. How do I calculate time between in and out (keeping in mind that there will be overnight shifts). Thanks- Donna -- dkostel ------------------------------------------------------------------------ dkostel's Profile: http://www.excelforum.com/member.php...o&userid=16794 View this thread: http://www.excelforum.com/showthread...hreadid=319903 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| Date and time calculations | Excel Discussion (Misc queries) | |||
| Time sheet set up specifically | New Users to Excel | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
