The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [OT] Excel Time Calculations


  • To: <ukha_d@xxxxxxx>
  • Subject: RE: [OT] Excel Time Calculations
  • From: "Jonathan Farmer" <jonathan@xxxxxxx>
  • Date: Sun, 28 Oct 2001 22:45:36 -0000
  • Delivered-to: mailing list ukha_d@xxxxxxx
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@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.

Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.