Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

time in seconds

Posted on 2008-10-14
2
Medium Priority
?
274 Views
Last Modified: 2012-06-27
I want diff of time in sconds...when i minus starttime with end time and multiply with 84600 it gives me correct sconds but followed by 00:00:00...i just want to have seonds in my colum not the zeors
0
Comment
Question by:muhammadaqeel
1 Comment
 
LVL 12

Accepted Solution

by:
RWrigley earned 200 total points
ID: 22734914
Try changing to the display format to "Time Interval".
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Integration Management Part 2
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question