#1   Report Post  
Old April 4th 05, 10:29 PM
Steved
 
Posts: n/a
Default Decimal Time

Hello from Steved

I would like a formula please to add 8 minutes to below
please they are in Decimal.

8.25 will be 8.33
11.57 will be 12.05

Thankyou in Advance

  #2   Report Post  
Old April 4th 05, 10:38 PM
Jason Morin
 
Posts: n/a
Default

=A1+TIME(,8,)
=A1+8/24/60
=A1+"00:08"

All of these will add 8 min.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello from Steved

I would like a formula please to add 8 minutes to below
please they are in Decimal.

8.25 will be 8.33
11.57 will be 12.05

Thankyou in Advance
.

  #3   Report Post  
Old April 4th 05, 10:57 PM
JE McGimpsey
 
Posts: n/a
Default

one way:

=HOUR(TIME(A1,MOD(A1,1)*100+8,0)) +
MINUTE(TIME(0,MOD(A1,1)*100+8,0))/100

In article ,
"Steved" wrote:

Hello from Steved

I would like a formula please to add 8 minutes to below
please they are in Decimal.

8.25 will be 8.33
11.57 will be 12.05

Thankyou in Advance

  #4   Report Post  
Old April 4th 05, 10:58 PM
JE McGimpsey
 
Posts: n/a
Default

But none of them return 8.33 when A1 = 8.25.


In article ,
"Jason Morin" wrote:

=A1+TIME(,8,)
=A1+8/24/60
=A1+"00:08"

All of these will add 8 min.

  #5   Report Post  
Old April 4th 05, 11:02 PM
Steved
 
Posts: n/a
Default

Thankyou J E
-----Original Message-----
one way:

=HOUR(TIME(A1,MOD(A1,1)*100+8,0)) +
MINUTE(TIME(0,MOD(A1,1)*100+8,0))/100

In article ,
"Steved" wrote:

Hello from Steved

I would like a formula please to add 8 minutes to below
please they are in Decimal.

8.25 will be 8.33
11.57 will be 12.05

Thankyou in Advance

.



  #6   Report Post  
Old April 4th 05, 11:05 PM
Steved
 
Posts: n/a
Default

Hello Jason From Steved

Your formulas were adding 1 minute
using your formula 8.00 would become 8.01.

What Shoud I have formatted the cell to get your formula
to work.

Thankyou.


-----Original Message-----
=A1+TIME(,8,)
=A1+8/24/60
=A1+"00:08"

All of these will add 8 min.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello from Steved

I would like a formula please to add 8 minutes to below
please they are in Decimal.

8.25 will be 8.33
11.57 will be 12.05

Thankyou in Advance
.

.

  #7   Report Post  
Old April 5th 05, 03:37 AM
Jason Morin
 
Posts: n/a
Default

I assumed your values were time values, formatted as
[h].mm. When A1 = 8.25 (or the numerical value 0.350694),
all 3 formulas return 8.33.

If you simply have 8.25 keyed into a cell, then this
would actually represent 8 days, 6 hours. In this case,
use J.E.'s formula.

Sorry for the confusion.

Jason

-----Original Message-----
Hello Jason From Steved

Your formulas were adding 1 minute
using your formula 8.00 would become 8.01.

What Shoud I have formatted the cell to get your formula
to work.

Thankyou.


-----Original Message-----
=A1+TIME(,8,)
=A1+8/24/60
=A1+"00:08"

All of these will add 8 min.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello from Steved

I would like a formula please to add 8 minutes to below
please they are in Decimal.

8.25 will be 8.33
11.57 will be 12.05

Thankyou in Advance
.

.

.



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
If Statement - in time not decimal minutes Sue Excel Worksheet Functions 1 March 30th 05 04:35 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
Show a time from one calculated cell as a decimal in another cell. KathyS Excel Worksheet Functions 1 January 20th 05 01:00 AM
Subtract Decimal time Steved Excel Worksheet Functions 9 December 1st 04 07:47 PM
decimal time subtraction please. Steved Excel Worksheet Functions 6 November 25th 04 01:07 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017