RE: [OT] Excel Time Calculations

["Jonathan Farmer" <jonathan@xxxxxxx>]

Don

 

I have a spreadsheet that does exactly what you want, BUT it's at work.

 

Can it wait until then?

 

Cheers

 

Jonny

 

-----Original Message-----
From: Don McAllister [mailto:donmc@xxxxxxx]
Sent: 28 October 2001 22:26
To: ukha_d@xxxxxxxSubject: [ukha_d] [OT] Excel Time Calculations

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

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.

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.