How to add total of Hours and Minutes

K

kyle

New member
Joined
May 27, 2014
Messages
12
Reaction score
0
Points
0
Hi All

I need help working out how to calculate hours and minutes
I entered the values in a cell as 4.15, 10.55, 6.30 etc (4hrs 15mins)
Is this possible to add total hours and minute. or do I need to enter this in as a different format

I have included a basic example see attached

Thanks in advance for the help

Regard
Kyle
 

Attachments

  • time.xls
    31 KB · Views: 13
Take a look at this there's a couple of ways you can do what your looking for.
It's in the tenth of hours which is what you're looking for.
 

Attachments

  • time.xls
    40.5 KB · Views: 11
Hi Al

Thank you all so much for your replies, its so much appreciated that something that seems easy enough for some can do your head in..
Hopefully one day I will be able to help others when they need help.

Cheers
kyle
 
You must log in or register to reply here.
Back
Top