|
|
#1
08-22-2006, 08:51 AM
|
|||
|
|||
How to get cells to calculate time?
I am having a difficult time in figuring out what formula to use.
I use Excel for a timesheet format In cell A1----7:30 a.m. In cell A2----4:00 p.m. I want A3 to autosum the total amount of these hours, which is 8... What formula do I use? Thanks!!!! :D 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| format cells to automatically place quotes around text | dirtleg | Excel | 1 | 09-16-2008 01:52 PM |
 How to stop correcting zeroes in cells ?
|
kevin_ms | Excel | 4 | 09-14-2008 10:08 PM |
| Nested if formulat to merge cells | cristi22 | Excel | 0 | 10-23-2006 08:28 AM |
| Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |
| How to count cells containing data and meet certain criteria | AdamNT | Excel | 1 | 08-11-2006 11:51 PM |
Threaded Mode