Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
G'day All,
I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
I think that your problem might be in the way you are entering the times. All
times must be entered as h:m:s.0 etc. If you want to enter .15 seconds then enter it as 0:0:0.15. You can set the format to display only minutes and seconds but you must enter the hour when entering the value. Regards, OssieMac "build" wrote: G'day All, I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
Just add them
Assume the values are in A =A1+"0:0:0.150" use the same format as before or put the fractions in another cell and add the cells you can also use =150/86400/1000 or =150/24/60/60/1000 equals 0:00.15 so =A1+(150/24/60/60/1000) -- Regards, Peo Sjoblom "build" wrote in message ... G'day All, I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
G'day Ossie,
Good name! You must be a great bloke. Ossie Ossie Ossie Oi Oi Oi. LOL If I enter 1:26.493 and 0:00.150 in cells and add them it works well. However if I want to do that in a formula I need to use =A3+TIME(0,0,0.15) and that does not work. Is that a bit clearer? Thanks again in anticipation, build "OssieMac" wrote in message ... I think that your problem might be in the way you are entering the times. All times must be entered as h:m:s.0 etc. If you want to enter .15 seconds then enter it as 0:0:0.15. You can set the format to display only minutes and seconds but you must enter the hour when entering the value. Regards, OssieMac "build" wrote: G'day All, I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
What I said before is semi right in that it will work. I just tested it and
you can enter just the minutes and seconds when you have a decimal after the seconds. Example:- 1:26.15 is 1m 26.15secs and can be entered this way. However, if you enter 1:26 then that becomes 1hr 26mins. If you just enter .15 then that converts to 3hrs 36 mins. 0:0.15 is .15secs. Regards, OssieMac "OssieMac" wrote: I think that your problem might be in the way you are entering the times. All times must be entered as h:m:s.0 etc. If you want to enter .15 seconds then enter it as 0:0:0.15. You can set the format to display only minutes and seconds but you must enter the hour when entering the value. Regards, OssieMac "build" wrote: G'day All, I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
And G'day to You.
Try this:- =A3+VALUE("0:0:0.15") Assuming that A3 is a time and the cell with the formula is also formatted to time. Regards, OssieMac "build" wrote: G'day Ossie, Good name! You must be a great bloke. Ossie Ossie Ossie Oi Oi Oi. LOL If I enter 1:26.493 and 0:00.150 in cells and add them it works well. However if I want to do that in a formula I need to use =A3+TIME(0,0,0.15) and that does not work. Is that a bit clearer? Thanks again in anticipation, build "OssieMac" wrote in message ... I think that your problem might be in the way you are entering the times. All times must be entered as h:m:s.0 etc. If you want to enter .15 seconds then enter it as 0:0:0.15. You can set the format to display only minutes and seconds but you must enter the hour when entering the value. Regards, OssieMac "build" wrote: G'day All, I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
That works.
Appreciate. Oi! build "OssieMac" wrote in message ... And G'day to You. Try this:- =A3+VALUE("0:0:0.15") Assuming that A3 is a time and the cell with the formula is also formatted to time. Regards, OssieMac "build" wrote: G'day Ossie, Good name! You must be a great bloke. Ossie Ossie Ossie Oi Oi Oi. LOL If I enter 1:26.493 and 0:00.150 in cells and add them it works well. However if I want to do that in a formula I need to use =A3+TIME(0,0,0.15) and that does not work. Is that a bit clearer? Thanks again in anticipation, build "OssieMac" wrote in message ... I think that your problem might be in the way you are entering the times. All times must be entered as h:m:s.0 etc. If you want to enter .15 seconds then enter it as 0:0:0.15. You can set the format to display only minutes and seconds but you must enter the hour when entering the value. Regards, OssieMac "build" wrote: G'day All, I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Fractions of a Second
No need to use VALUE when you convert text in a calculation, the calculation
itself will take care of that, besides I posted this solution an hour earlier -- Regards, Peo Sjoblom "OssieMac" wrote in message ... And G'day to You. Try this:- =A3+VALUE("0:0:0.15") Assuming that A3 is a time and the cell with the formula is also formatted to time. Regards, OssieMac "build" wrote: G'day Ossie, Good name! You must be a great bloke. Ossie Ossie Ossie Oi Oi Oi. LOL If I enter 1:26.493 and 0:00.150 in cells and add them it works well. However if I want to do that in a formula I need to use =A3+TIME(0,0,0.15) and that does not work. Is that a bit clearer? Thanks again in anticipation, build "OssieMac" wrote in message ... I think that your problem might be in the way you are entering the times. All times must be entered as h:m:s.0 etc. If you want to enter .15 seconds then enter it as 0:0:0.15. You can set the format to display only minutes and seconds but you must enter the hour when entering the value. Regards, OssieMac "build" wrote: G'day All, I have a table of times in the format m:ss.000 i.e. 1:26.072 1:26.493 1:26.556 1:26.755 I want to add fractions of a second to these times. i.e. 1:26.072 + 0:00.15 I have tried the TIME() function but it does not work with fractions of a second. Thanking you in anticipation, build |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fractions | Excel Worksheet Functions | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) |