excel sheet
-
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.
-
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] -
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.
-
Frank,
You may have a German keyboard!
On a "normal" keyboard STRG calls CTRL
(Control anstatt Steuerung)
Bye
Gabor -
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