Posts by ParanoidAndroid

    Re: Converting Minutes into Hours and Minutes using a Formula


    For total minutes less than 1440 you can use excel's built in TIME function.


    =TIME(0,minutes,0) will convert your minutes into a decimal time serial number. You can either format this to show the hours and minutes, or reference the cell with =hour(cell) and =minute(cell)


    If the total minutes is more than 1440, you need to work out the number of days. You can use the MOD function like so: =MOD(minutes,1440).


    This gives you the number of days, so if you need the answer in hours you will need to multiply by 24.

    Re: Can formula change when another cell changes?


    I would use the INDIRECT funtion


    This allows you to create a cell ref with a formula and use it as a range.


    from your example:


    CellA2 : "Team1"
    ThisCell : =INDIRECT(CellA2&"!Q153")