LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default calculate the the diffrence between 2 Dates and time

I am trying to create a formula that calculates the diffrence beween the date
and the time. I.e result would be 3d 10m ot 3d 10m30s. Can anyone help??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
time diffrence with 24 hour clock Rich Mcc Excel Worksheet Functions 3 October 25th 06 03:39 PM
Please Help Calculate Time Between 2 different Dates Dtown Dawg Excel Discussion (Misc queries) 6 September 12th 06 07:42 PM
Calculate Time To Respond from Dates BaldySlaphead Excel Discussion (Misc queries) 2 March 2nd 06 12:50 PM
Cells with time format and calculating the diffrence MikeR-Oz New Users to Excel 11 January 3rd 06 10:11 AM
How to calculate time between two dates? ByGolly! Setting up and Configuration of Excel 1 February 12th 05 03:42 PM


All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"