Re: cell properties. hours?

Tech-Archive recommends: Fix windows errors by optimizing your registry



Custom format: [h]:mm

HTH
--
AP

"bobbych" <bobbych.29up4b_1151058901.6152@xxxxxxxxxxxxxxxxxxxxx> a écrit
dans le message de news:
bobbych.29up4b_1151058901.6152@xxxxxxxxxxxxxxxxxxxxxxxx

hi

i need to create a setup where i input the running hours and mins for a
component. This input will add to a diff cell which contains total
running hours and mins.

eg hours used today=3:40 need to add this to total hours

total hours =11350:20

cell properties does not have a setup for hhhhh:mm only hh:mm
is it possible?
cheers


--
bobbych
------------------------------------------------------------------------
bobbych's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=35706
View this thread: http://www.excelforum.com/showthread.php?threadid=554911



.



Relevant Pages

  • cell properties. hours?
    ... This input will add to a diff cell which contains total ... running hours and mins. ... cell properties does not have a setup for hhhhh:mm only hh:mm ... bobbych's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35706 ...
    (microsoft.public.excel.misc)
  • Re: LogMeIn Ignition...
    ... rather than mouse pointer control and it works over the internet via ... Takes about 5 mins to setup, ...
    (uk.comp.sys.mac)
  • Re: Shortened DX Frame.
    ... yeah, i just thought that setup was going on a trials uni. ... i realized it like 10 mins after i posted, i thought it might be some ...
    (rec.sport.unicycling)
  • New Install problem
    ... after I run setup for a new installation it takes my ... server about 30 mins to give a log in screen and I then ... computer and it again takes about 30 mins to allow access ... Every time I restart it repeats this. ...
    (microsoft.public.windows.server.sbs)