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

I am trying to do a calculation using difference between two hour:minute time
data in the following format.

A1 B1
02:50 03:00

When I subtract (B1-A1) I get an answer 0:10 and I can change this to 10 by
custom formatting the cell to [mm]

I want to use this value of 10 mins to divide a distance value to get
answers in ft/min format. e.g. 100 ft divided by 10 mins = 10 ft/min

But this is where my problem starts. I get some obscure high number as
excel reads 10 mins as 0.0069444.

Please help & advise. Many thanks in advance.
 
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
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM
rounding time question lbfries Excel Worksheet Functions 3 April 6th 05 08:23 PM
Question for Peo Jim Excel Worksheet Functions 1 January 13th 05 07:59 PM
Help - Information with time and date PM Excel Discussion (Misc queries) 4 January 6th 05 08:25 AM


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