| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert & multiply (number & time)formulas
I need help with a couple of issues in the same table.
-the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
Hi Targueta,
0.84 of an hour doesnt make 48 mins. With 0.84 in A1 In B1 put =A1/24 (and format as custom [h]:mm:ss) will show as 0:50:24 In C1 put =B1*320 (and format as custom [h]:mm:ss) will show as 268:48:00 Is that something you can work with? HTH Martin "targueta" wrote: I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
Thanks I works perfectly
"MartinW" wrote: Hi Targueta, 0.84 of an hour doesnt make 48 mins. With 0.84 in A1 In B1 put =A1/24 (and format as custom [h]:mm:ss) will show as 0:50:24 In C1 put =B1*320 (and format as custom [h]:mm:ss) will show as 268:48:00 Is that something you can work with? HTH Martin "targueta" wrote: I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
Glad to hear that. Thanks for posting back.
Regards Martin "targueta" wrote in message ... Thanks I works perfectly "MartinW" wrote: Hi Targueta, 0.84 of an hour doesnt make 48 mins. With 0.84 in A1 In B1 put =A1/24 (and format as custom [h]:mm:ss) will show as 0:50:24 In C1 put =B1*320 (and format as custom [h]:mm:ss) will show as 268:48:00 Is that something you can work with? HTH Martin "targueta" wrote: I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
Hi,
Try this as the answer to the first question TEXT(MID(A1,1,FIND(".",A1,1)-1)&":"&MID(A1,FIND(".",A1,1)+1,10),"[hh]:mm") -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "targueta" wrote in message ... I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
thanks I apreciate the help
"Ashish Mathur" wrote: Hi, Try this as the answer to the first question TEXT(MID(A1,1,FIND(".",A1,1)-1)&":"&MID(A1,FIND(".",A1,1)+1,10),"[hh]:mm") -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "targueta" wrote in message ... I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
You will have realised, I hope, that Ashish's formula converts your 0.84
into 0:84:00, in other words 1:24:00 in h:mm:ss. Other users have assumed that by 0.84 you mean 0.84 hours, or 0:50:24 in h:mm:ss. -- David Biddulph "targueta" wrote in message ... thanks I apreciate the help "Ashish Mathur" wrote: Hi, Try this as the answer to the first question TEXT(MID(A1,1,FIND(".",A1,1)-1)&":"&MID(A1,FIND(".",A1,1)+1,10),"[hh]:mm") -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "targueta" wrote in message ... I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
That's a very strange post David. What does it mean?
Signed Other User "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... You will have realised, I hope, that Ashish's formula converts your 0.84 into 0:84:00, in other words 1:24:00 in h:mm:ss. Other users have assumed that by 0.84 you mean 0.84 hours, or 0:50:24 in h:mm:ss. -- David Biddulph "targueta" wrote in message ... thanks I apreciate the help "Ashish Mathur" wrote: Hi, Try this as the answer to the first question TEXT(MID(A1,1,FIND(".",A1,1)-1)&":"&MID(A1,FIND(".",A1,1)+1,10),"[hh]:mm") -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "targueta" wrote in message ... I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert & multiply (number & time)formulas
What is strange about it? Your interpretation is the same as mine and
David's that 0.84 hour = 50 minutes and 24 seconds whereas the other formula incorrectly returns 1 hours and 24 minutes as a text value -- Regards, Peo Sjoblom "MartinW" wrote in message ... That's a very strange post David. What does it mean? Signed Other User "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... You will have realised, I hope, that Ashish's formula converts your 0.84 into 0:84:00, in other words 1:24:00 in h:mm:ss. Other users have assumed that by 0.84 you mean 0.84 hours, or 0:50:24 in h:mm:ss. -- David Biddulph "targueta" wrote in message ... thanks I apreciate the help "Ashish Mathur" wrote: Hi, Try this as the answer to the first question TEXT(MID(A1,1,FIND(".",A1,1)-1)&":"&MID(A1,FIND(".",A1,1)+1,10),"[hh]:mm") -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "targueta" wrote in message ... I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I need to covert this to hours: minutes (what should be 0:48) -the second one is: I need to multiply the previous time (0:48) by a Quantity (example: 320) and get the result in hours: minutes (what should be 256:00) Can any one help? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert time stored as decimalised number to time format | New Users to Excel | |||
| How to: Convert time value to a number | Excel Worksheet Functions | |||
| Convert number to time | Excel Discussion (Misc queries) | |||
| Convert a number to a time | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Hybrid Mode
