Excel calculate total working hour RRS feed

  • Question

  • hi,

    There is datetime column from which i need to find dayofweak ie, whether it is sunday,monday,tuesday...etc..

    Then final output what i need is for sunday from 12:00:00 AM to 12:59:59 AM how many values  from 1:00:00 to 1:59:59 how many values  and so on are there .even if i cannot find how many if i can differentiate in a ny mean it is ok .


    Monday, April 6, 2015 3:51 AM


  • Hi,

    For this requirement, I think you need to iterate the data of each row and compare it.

    To check whether the string is the date type, we could use IsDate method, the result is true or false.

    To convert the string to date, we could use CDate method.

    To check whether the date is Sunday, Monday etc…, we could use Weekday method, the result is integer.



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, April 7, 2015 3:15 AM