LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
wu-fu
 
Posts: n/a
Default problem with formula

I have one column with increasing standard time (hr:min:sec). I put a
formula in the first cell of the first row of a second column to convert the
same cell of the first column to a value of decimel based upon minutes. The
result is correct in the first cell of the first line (row) where the the
formula was placed in the second column, but when I copy the formula
throughout the rows of the second column, the results shown are always the
answer for the first line - even though when I klick on the cell the formula
in the lower rows/cells shows it referring to the correct later time of the
lower row & cell.

Why??? is my Excel corrupted?? The value shown by the cell does not fit
formula of the cell!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula problem on network Philip Reece-Heal Excel Discussion (Misc queries) 2 July 1st 05 01:15 PM
problem with Array Formula OrdOff Excel Worksheet Functions 2 June 30th 05 04:57 PM
Problem with formula Sundaram Iyer Excel Discussion (Misc queries) 0 June 1st 05 12:49 AM
Named SUM Formula with relative refernce(s) Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM
Need a formula for this problem Trying to excel in life but need help Excel Worksheet Functions 1 January 12th 05 11:05 AM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"