Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timing Conversion problem
I want to convert number to hour like this.
Num Hour 1.00 1.00 6.50 6.30 0.25 0.15 3.75 3.45 Anyone has any idea, what sort of formula i have to put on excel sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timing Conversion problem
With the number in A1, =INT(A1)+(A1-INT(A1))*0.6 will do the conversion.
Just format in the comma style to get the two decimal points that represent the minutes. "Help on Excel sheet formula" wrote: I want to convert number to hour like this. Num Hour 1.00 1.00 6.50 6.30 0.25 0.15 3.75 3.45 Anyone has any idea, what sort of formula i have to put on excel sheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timing Conversion problem
Try this:
=INT(A1)+MOD(A1,1)*60/100 Format as NUMBER 2 decimal places Biff "Help on Excel sheet formula" <Help on Excel sheet wrote in message ... I want to convert number to hour like this. Num Hour 1.00 1.00 6.50 6.30 0.25 0.15 3.75 3.45 Anyone has any idea, what sort of formula i have to put on excel sheet. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timing Conversion problem
That's good.
Problem solved. Thanks mate. "bpeltzer" wrote: With the number in A1, =INT(A1)+(A1-INT(A1))*0.6 will do the conversion. Just format in the comma style to get the two decimal points that represent the minutes. "Help on Excel sheet formula" wrote: I want to convert number to hour like this. Num Hour 1.00 1.00 6.50 6.30 0.25 0.15 3.75 3.45 Anyone has any idea, what sort of formula i have to put on excel sheet. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timing Conversion problem
Rather than using 6.30 to represent 6 hours and 30 minutes, and risk
confusion, better to use 6:30, which you can get merely by =A1/24 and format as h:mm (or as [h]:mm if it might be beyond 24 hours). -- David Biddulph "Help on Excel sheet formula" <Help on Excel sheet wrote in message ... I want to convert number to hour like this. Num Hour 1.00 1.00 6.50 6.30 0.25 0.15 3.75 3.45 Anyone has any idea, what sort of formula i have to put on excel sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion problem | Excel Discussion (Misc queries) | |||
Date Conversion Problem | Excel Discussion (Misc queries) | |||
Problem in Conversion | Excel Discussion (Misc queries) | |||
Timing problem with OnAction! | Charts and Charting in Excel | |||
Excel 97 to 2003 conversion problem | Excel Discussion (Misc queries) |