excel sheet

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  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.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]

• bapindeb

  Old Hand

  Points: 364

  More actions

  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.

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  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

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]