Hours counting


Posted by dzevad on January 17, 2001 12:36 AM

i made calender which should cpunt how many hours i worked each day and then should add at end of the month amount from each day. I made it with format hh:mm so i can write, i came at 7:30 or something and was there until 18:00, amount of it should be then 10:30. That works good, only at end of the month i come to 180 hours or something and excel calculates it into days, means if i have f.e. 166:00 hours so far, he shows me follows "06.01.1900 22:00". My question is, How can i make him write down more then 24:00 ..
Thank you very much



Posted by Dave Hawley on January 17, 2001 2:17 AM

Hi dzevad

Format your cell as Custom: [h]:mm:ss


Dave

  • OzGrid Business Applications