[OT] Excel Time Calculations

["Don McAllister" <donmc@xxxxxxx>]

OK Guys and Gals, I hope you don’t mind if I slip in a quick OT request !

 

Basically, I want to create an excel spreadsheet that calculates Hours and minutes worked in the week. No problem sorting out the daily hours and minutes worked but I want to create a weekly total of hours and minutes. When I sum the weeks daily times I can only produce an entry like:

 

01:10:30

 

when I really want

 

34:30

 

i.e. it won’t display more than 24 hours without flipping into days. I know you can multiply the time by 24 but this gives 34.5 not 34:30

 

Any clues ?

 

TIA

 

Don

Yahoo! Groups Sponsor

ADVERTISEMENT

For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.