Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steved
 
Posts: n/a
Default decimal time subtraction please.

Hello from Steved

Below is Decimal

Each minute = 60

7.45 minus 8.35 to leave 50 please

Formula for the above

Thankyou.
  #2   Report Post  
crispbd
 
Posts: n/a
Default


In Cell A1: 8.35
In Cell B1: 7.45

=(VALUE(LEFT(A1,LEN(A1)-3)) * 60 + VALUE(RIGHT(A1,2))) -
(VALUE(LEFT(B1,LEN(B1)-3)) * 60 + VALUE(RIGHT(B1,2)))


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=320247

  #3   Report Post  
Steved
 
Posts: n/a
Default

Thankyou


-----Original Message-----

In Cell A1: 8.35
In Cell B1: 7.45

=(VALUE(LEFT(A1,LEN(A1)-3)) * 60 + VALUE(RIGHT(A1,2))) -
(VALUE(LEFT(B1,LEN(B1)-3)) * 60 + VALUE(RIGHT(B1,2)))


--
crispbd
----------------------------------------------------------

--------------
crispbd's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=10880
View this thread:

http://www.excelforum.com/showthread...hreadid=320247

.

  #4   Report Post  
Steved
 
Posts: n/a
Default

Hello crispbd from Steved

Is it possible please to make your formula more robust
ie 9.00 - 7.00
If I put in 9.05 - 7.05 returns 120 but type in 9.00 -
7.00 it returns #value!

Thankyou.

-----Original Message-----

In Cell A1: 8.35
In Cell B1: 7.45

=(VALUE(LEFT(A1,LEN(A1)-3)) * 60 + VALUE(RIGHT(A1,2))) -
(VALUE(LEFT(B1,LEN(B1)-3)) * 60 + VALUE(RIGHT(B1,2)))


--
crispbd
----------------------------------------------------------

--------------
crispbd's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=10880
View this thread:

http://www.excelforum.com/showthread...hreadid=320247

.

  #5   Report Post  
crispbd
 
Posts: n/a
Default


9.00 - 7.00 returned 120 for me. Try formatting the decimal time column
as text (making sure that 2 decimal places are shown)


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=320247



  #6   Report Post  
Steved
 
Posts: n/a
Default

Hello Crispbd from Steved

Thanks but by doing by your formula if I type 8 and hit
enter it will put 8 but having it formatted as a number
then I type 8 the result will be 8.00, as I've several off
these I would prefer a formula that would work with 8.00
not 8 as a text number.

Thanks.




-----Original Message-----

9.00 - 7.00 returned 120 for me. Try formatting the

decimal time column
as text (making sure that 2 decimal places are shown)


--
crispbd
----------------------------------------------------------

--------------
crispbd's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=10880
View this thread:

http://www.excelforum.com/showthread...hreadid=320247

.

  #7   Report Post  
Steved
 
Posts: n/a
Default

Hello from Steved

I've found a solution

DOLLARFR(DOLLARDE(M306,60)-DOLLARDE(C306,60),60)

Cheers.

-----Original Message-----

9.00 - 7.00 returned 120 for me. Try formatting the

decimal time column
as text (making sure that 2 decimal places are shown)


--
crispbd
----------------------------------------------------------

--------------
crispbd's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=10880
View this thread:

http://www.excelforum.com/showthread...hreadid=320247

.

Reply
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
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 11:24 PM
entering numbers to display a time format Ian Williams/Eazygig Excel Discussion (Misc queries) 1 January 10th 05 12:57 PM
Help - Information with time and date PM Excel Discussion (Misc queries) 4 January 6th 05 09:25 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 01:07 AM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 04:24 PM


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

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

About Us

"It's about Microsoft Excel"