Solved

MOSS Calculated Column - Days Hours Minutes SECONDS

Posted on 2010-09-02
737 Views
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
Question by:melli111
1 Comment

LVL 15

Accepted Solution

melli111 earned 0 total points

&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

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: …