It's unclear how you are entering your data. 30 minutes would normally be
entered as either 0:30 (30 minutes) or 0.5 (half an hour). 1h20min would be
either 1:20 (h:mm) or 1.33 (1 and one-third hours). But it looks like you
are entering this as 1.20.

Entering 1 hour and 20 minutes as 1.20 makes it impossible to add up, as you
have found. My best recommendation is to enter either times (1:20) or hours
(1.33). Then they will add properly.

Regards,
Fred.

"DR" wrote in message
...
Hi,

I have to fill the time sheet, in that i have to give activity name and
hours i worked on the activity.when I sum the total of hours i worked ,it
is
taking as normail No..Can i get any formula to covert it in to hours and
minuts

Ex : A1 activity i worked for 30mins (.30) , A2 activity I work... 1h.20
min
(1.20) , A3 - 1h .50m (1.50)

if I sum the total it had to show 3h.40min (but it is showing as 3 )

Can I get any formula for this ...?