Search:

Thanks for your help. Today has certainly been an education in Excel. I have formatted the cells as you suggested, bingo! And a friend of mine helped me with the formula:
...

Thanks for taking the time to reply.

jcaron2 - I have applied the formula you kindly suggested but I am getting a #VALUE error in the cell now.

JBeaucaire - when I enter my time duration as...

Hi, hoping someone can help me. I think I am trying to find one formula to do two things here. The first is to change the way my hours.minutes are displayed. For example, if I enter 1.30...