Post reply

excel sheet

  • August 21, 2003 at 8:05 am

    #358232

    Hi,

    Here is a question which is not related to sql server but can anyone help me in this issue.

    I have been creating an excel time sheet.In the time in my columns if enter 5:25 and 5:45 values in two columns it should display the total as 11:10 hrs time instead of 10:70(which is normal arithimatic value).what should be the data type of the column and how should i do that.

    Any help is appreciated.

    Thanks in advance.

  • August 21, 2003 at 8:27 am

    #470783

    Hi Bruce,

    quote:

    I have been creating an excel time sheet.In the time in my columns if enter 5:25 and 5:45 values in two columns it should display the total as 11:10 hrs time instead of 10:70(which is normal arithimatic value).what should be the data type of the column and how should i do that.

    goto the cell in question, hit STRG+1, you should see a format Popup. Now you have two alternatives:

    1. Choose category time and then the appropriate format.

    2. Choose category 'Userdefined' and then Typ: 'hh:mm'

    Cheers,

    Frank

    Sorry for editing, but I'm still soo excited

    Edited by - a5xo3z1 on 08/21/2003 08:28:04 AM

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 21, 2003 at 11:56 pm

    #470919

    when you put 5:45 in a cell it automatically sets the datatype of the cell 'DATE'(hh:mm format).So when you get SUM using formula it will autometically give you 11:10.

  • August 22, 2003 at 6:42 am

    #470955

    Frank,

    You may have a German keyboard!

    On a "normal" keyboard STRG calls CTRL

    (Control anstatt Steuerung)



    Bye
    Gabor

  • August 22, 2003 at 6:50 am

    #470958

    quote:

    You may have a German keyboard!

    On a "normal" keyboard STRG calls CTRL

    (Control anstatt Steuerung)

    Auf meiner Tastatur steht 'Hewlett Packard'!

    Anyway, from the menubar use Format -> Cells

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply