MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by tim on June 17, 2001 5:36 PM

i am a time keeper at my work. i would like to develop or get my microsoft excel to add time based on a 60 minute hour rather than an hour divided into 100 equal parts. example: 1.45 + 1.45 = 3.30 rather than those same two numbers equaling 2.90. help!

Posted by zen on June 18, 2001 3:03 AM

Hi Tim,
If you use ":" as you spacer it wil automatically set the value ot TIMEVALUE(), you can go into format cells and change the setting to time, but you will still have to use the colon. Also you if you say wanted to key in 1.30 you have to put the end 0 on otherwise it'll look like this 1:03. Another thing is you can't have negative time values i.e. 14:30 - 15:00 will give you a cell full of lovely ########'s. I use time all lot in my job so if you need any help you e.mail me. with regard to that last problem what I do (because it is only a variance after all) is, change it back to Number with two decimals and with the formula just put =(a1-b1)*24

hope that's helpful any thing else just e.mail, as i said i you time all the bleedin time (no pun intended) and it's a nightmare