Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=SUM question
New to excel.
Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and have the answer in fractions...in this case 25.75 Thanks |
#2
|
|||
|
|||
John
=SUM(A1:A3)*24 and format the result as General Regards Trevor "John Smith" wrote in message ... New to excel. Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and have the answer in fractions...in this case 25.75 Thanks |
#3
|
|||
|
|||
John
also new to News Groups ? Please don't multi-post. You have had the same answer from two different people in two different groups. The same people look at pretty much all of the related groups so by doing this you're wasting everyone's time and effort. Regards Trevor "John Smith" wrote in message ... New to excel. Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and have the answer in fractions...in this case 25.75 Thanks |
#4
|
|||
|
|||
See one reply to your post in m.p.e.newusers.
Please don't post the same message in multiple groups. It just fragments any answers you get, and potentially wastes the time of those replying to questions that have already been answered. For tips on using these groups effectively, see http://cpearson.com/excel/newposte.htm In article , "John Smith" wrote: New to excel. Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and have the answer in fractions...in this case 25.75 Thanks |
#5
|
|||
|
|||
Thank you.
I get 18! Can you assist further please? ...and not sure what format the result as General means. Thanks John -------------------- format the resulting cell with the custom format [hh]:mm "Trevor Shuttleworth" wrote in message ... John =SUM(A1:A3)*24 and format the result as General Regards Trevor "John Smith" wrote in message ... New to excel. Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and have the answer in fractions...in this case 25.75 Thanks |
#6
|
|||
|
|||
Point taken, Trevor.
----------------- "Trevor Shuttleworth" wrote in message ... John also new to News Groups ? Please don't multi-post. You have had the same answer from two different people in two different groups. The same people look at pretty much all of the related groups so by doing this you're wasting everyone's time and effort. Regards Trevor "John Smith" wrote in message ... New to excel. Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and have the answer in fractions...in this case 25.75 Thanks |
#7
|
|||
|
|||
Ah, now understood and sorted.
TVM for the advice. John ------------------- "Trevor Shuttleworth" wrote in message ... John =SUM(A1:A3)*24 and format the result as General Regards Trevor "John Smith" wrote in message ... New to excel. Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and have the answer in fractions...in this case 25.75 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Question Please | Excel Discussion (Misc queries) | |||
Compare Question | Excel Discussion (Misc queries) | |||
Question on VBA | Excel Discussion (Misc queries) | |||
Advanced Window Split & Freeze Question | Excel Worksheet Functions | |||
Have a question on scrolling sum with Excel. | Excel Worksheet Functions |