It certainly can!!

Much obliged and it’s probably best if you forward it to me direct rather than via the group.

Many thanks

Don

-----Original Message-----
From: Jonathan Farmer [mailto:jonathan@xxxxxxx]
Sent: 28 October 2001 22:46
To: ukha_d@xxxxxxx Subject: RE: [ukha_d] [OT] Excel Time Calculations

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@xxxxxxx Subject: [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.

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.

The UK Home Automation Archive

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024

RE: [OT] Excel Time Calculations