Timing Conversion problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
That's good.

Problem solved. Thanks mate.

bpeltzer said:
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.
Click to expand...
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top