Solved

MOSS Calculated Column - Days Hours Minutes SECONDS

Posted on 2010-09-02
1
737 Views
Last Modified: 2012-05-10
I used the calculation shown in the solution here:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21867058.html

=INT(B1-A1)&"days "&INT(MOD(B1-A1,1)*24)&"hrs "&INT(MOD(MOD(B1-A1,1)*24,1)*60)&"mins"

That works great, but I would like to add the seconds on to it.  The fields I am calculating are values from an InfoPath form.
0
Comment
Question by:melli111
1 Comment
 
LVL 15

Accepted Solution

by:
melli111 earned 0 total points
Comment Utility
I just added this:

&SECOND(B1-A1)&" seconds"  

so the whole thing is:

=INT(B1-A1)&" days "&INT(MOD(B1-A1,1)*24)&" hrs "&INT(MOD(MOD(B1-A1,1)*24,1)*60)&" mins "&SECOND(B1-A1)&" seconds"
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

772 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now