View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tikchye_oldLearner57 tikchye_oldLearner57 is offline
external usenet poster
 
Posts: 77
Default filling in time in hours and minutes

hi community

how do i fill in say, I work 9 hours 45 minutes as my overtime work.

is it that I need to format the cell as h:mm and if up as 09:45 ?

if i do that, when i go into the edit mode, the formula bar will show me
something like 9:45:00 AM

please somebody clarify for me :)

thanks
--
oldLearner57