View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randy Randy is offline
external usenet poster
 
Posts: 213
Default Tiem Calculation

Anyone know how I can get these scenarios to calculate? I need to leave in
this format but need to calculate how much time, which in this case is 2
hours. I just need it to state 2, not the "hours" parts. I also need if to be
able to tell the difference between the two scenarios as either one may
entered in.

11:00 PM to 1:00 AM = 2
10:00 PM to 11:00 PM = 1

Also one last question....how come when 12:00 AM is enetered is does not
appear? Calulations still calculate but you can't see the 12:00 AM part?

Any assistance anyone can provide will be greatly appreciated. I thank you
in adavance for your time.


--
Randy Street
Rancho Cucamonga, CA