If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding times together
Hi
I need to add times together, i.e. 6:30, 5:30, 5:00 etc to get and answer of 17 hours Can someone help me with the formula please. Thanks Yvonne |
#2
|
|||
|
|||
Yvonne,
Just add them, and format the result cell as time. Time is just a fractional number in Excel, and it is the display for mat that makes it look like time. -- HTH Bob Phillips " osoft.com wrote in message ... Hi I need to add times together, i.e. 6:30, 5:30, 5:00 etc to get and answer of 17 hours Can someone help me with the formula please. Thanks Yvonne |
#3
|
|||
|
|||
If you enter the 3 times: 6:30, 5:30, 5:00 in say A1:A3
you could put in say, A4: =SUM(A1:A3) Format A4 as Custom, Type: [h]:mm to enable rollover of hours beyond 24 (with square brackets around the "h") -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- " osoft.com wrote in message ... Hi I need to add times together, i.e. 6:30, 5:30, 5:00 etc to get and answer of 17 hours Can someone help me with the formula please. Thanks Yvonne |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to view Start-End times in Day & WorkWeek view? | lllusion | Calendar | 2 | January 12th, 2005 01:04 PM |
How Many times Can I install MS OFFICE Pro ? | Jon | General Discussions | 2 | October 1st, 2004 03:08 AM |
Trying to count the number of times a "type" of value occurs | astiller | Worksheet Functions | 2 | July 9th, 2004 03:35 PM |
Adding auto-numbered field screws up Table order | Carl | Database Design | 5 | May 30th, 2004 03:25 AM |