LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
RA RA is offline
external usenet poster
 
Posts: 53
Default Hours difference

Need to calculate difference in terms of hours....weekend issue.
1st date and time - 1/29/10 (friday) 1:00am
2nd date and time - 2/1/10 (monday) 1:00am
By calculating manually, the result that i would need to show is 24 hrs
(based on my shop floor operations). Anything more than 24hrs is an issue at
my operations.
How would i do this in excel?
Thank you.
 
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 difference from 24 hours The Incredible Excel Discussion (Misc queries) 3 October 17th 08 01:20 PM
Calculating the difference between hours Oliver Excel Worksheet Functions 1 June 1st 08 07:48 PM
How Do I Get The Difference In Hours and Mins medicom06 Excel Worksheet Functions 4 August 12th 05 03:06 AM
How to get difference in hours Akhilesh Dalia Excel Worksheet Functions 6 April 23rd 05 06:41 AM
Difference in Hours Karan Excel Discussion (Misc queries) 4 April 21st 05 11:07 AM


All times are GMT +1. The time now is 11:19 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"