LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bcbjork
 
Posts: n/a
Default Difficult Time equation


This is my first post so hello everyone and thankyou in advance for any
assistance you can provide.

The diffuclty I am having is as follows:

I have a spreadsheet with two times


8:45 9:45

I need to find the difference in the two times as a decimal but as a
fraction of an hour..

for thesee times the answer I need is 0.25 not 0.15.

Can anyone help?


--
bcbjork
------------------------------------------------------------------------
bcbjork's Profile: http://www.excelforum.com/member.php...o&userid=26665
View this thread: http://www.excelforum.com/showthread...hreadid=399403

 
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 math USAOz Excel Worksheet Functions 2 August 14th 05 07:19 AM
Time Sheets smiller3128 New Users to Excel 1 August 4th 05 08:17 PM
Adding time damezumari Excel Discussion (Misc queries) 2 June 20th 05 08:35 PM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 03:24 PM


All times are GMT +1. The time now is 04:30 AM.

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"