Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello All,
I require help with the below formula. =(0+(33/60)+(18/(60*60)))*-1 Certain numbers in the formula change. The numbers that change are from left to right '0' '33' & '18'. In this instance the '0' was a negative value (hence the *-1 on the end of the formula). I have many rows in which these numbers vary. How can I target the formula at one cell (where the data source is, eg. -0:33:18) and place the result (in this case -0.555) in another? Sorry if I am not explaining very well. I hope you can understand it though. Thank you for your Help. David. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL GURU WANTED - Time calculations | Excel Worksheet Functions | |||
I need an excel guru! HELP! | Excel Discussion (Misc queries) | |||
Seeking an Excel guru in the Boston area - EXC102706 | Excel Discussion (Misc queries) | |||
I Need a math guru | Excel Discussion (Misc queries) | |||
Cut and Paste Question for an Excel Guru | Excel Discussion (Misc queries) |