Thread: Urgent Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Urgent Help

Your COUNTIF formula will return regular numbers. If these represent
hours, then you can convert them into time format by dividing by 24
and formatting the cell as Time or as Custom set to [h]:mm if the
number is likely to exceed 24. Then you can add both times together
and format the result as Time.

Hope this helps.

Pete

On Mar 24, 6:44*pm, "mapel" <u42370@uwe wrote:
Thank you this has worked, but is there anyway I can calculate using hours
rather than normal numbers.

Regards

Mark



art wrote:
If in the sheet that calculates the time is with the format of time then it
can't calculate it together with regular numbers. You need to replace for
e.g. 1:00 hour to the number 1 and then calculate as usual. Let me know if
this helps or not.


Please can someone help?


[quoted text clipped - 34 lines]


Mark- Hide quoted text -


- Show quoted text -