Help on Google Spreadsheet

Discussion in 'Google' started by p.caspian, Aug 30, 2011.

  1. #1
    Hello guys, I have got a problem. Its on google spreadsheet. I am little confused on posting this thread on this section. Anyways lets begin with the problem:

    Say you have got 3 cells named A, B and C

    A = In time
    B= Out time
    C = B-A

    for google spreadsheet A and B cells must be filled as the format hh:mm:ss am/pm. Now whenever the sum of those hours become 25 (say) then the result shows 1:00:00. But I want to show the result as 25:00:00.

    How can I do that?
     
    p.caspian, Aug 30, 2011 IP