I'm trying to make 3 rows. The first is hours and minutes, the second is wage, and the third is total. I tried using one of Office XP Professional formula's, but its not exact. I think thats because its counting the time wrong, but am not sure. Any help would be apprecitated. Thank you, Tom
XL stores times as fractional days, so you should multiply your hours and minutes by 24 to get integer hours (with minutes as fractional hours): A1: 7:30 A2: 10.00 A3: =A1*24*A2 ===> 75 Format A3 as Number. In article <RlIMf.7294$cF5.6631@news-wrt-01.rdc-nyc.rr.com>, "Tom" wrote: > I'm trying to make 3 rows. The first is hours and minutes, the second is > wage, and the third is total. I tried using one of Office XP Professional > formula's, but its not exact. I think thats because its counting the > time wrong, but am not sure. Any help would be apprecitated. > > > Thank you, > Tom
JE, Thank you for this formula. I will try it. Tom
OK,. I'm a little slow. Is this the way to write the ormula? -A1*24*A3=>75 ? Do I have to type sum=( ) ? Thanks alot. Tom "tom" wrote in message news:R0JMf.7296$cF5.5424@news-wrt-01.rdc-nyc.rr.com... > JE, > Thank you for this formula. I will try it. > Tom >
You should type =A1*24*A3 assuming A1 and A3 contain your elapsed time and wage (it will work in either order). An XL formula always starts with "=". In article <JbJMf.7297$cF5.6087@news-wrt-01.rdc-nyc.rr.com>, "tom" wrote: > OK,. I'm a little slow. Is this the way to write the > ormula? -A1*24*A3=>75 ? > > Do I have to type sum=( ) ?
Thanks again. "JE McGimpsey" wrote in message news:jemcgimpsey-7CA566.13353827022006@msnews.microsoft.com... > You should type > > > =A1*24*A3 > > > assuming A1 and A3 contain your elapsed time and wage (it will work in > either order). > > An XL formula always starts with "=". > > > In article <JbJMf.7297$cF5.6087@news-wrt-01.rdc-nyc.rr.com>, > "tom" wrote: > >> OK,. I'm a little slow. Is this the way to write the >> ormula? -A1*24*A3=>75 ? >> >> Do I have to type sum=( ) ?
