Thread
:
Timing Conversion problem
View Single Post
#
3
Posted to microsoft.public.excel.misc
T. Valko
external usenet poster
Posts: 15,768
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.
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko