date time conversion

  1. G

    Date, Time calculation

    Hi, I am calculating the hours, min (calling it opportunity) by multiplying available slots of 2 hrs and no of slots as 20. This means 20 hrs available time. Now, i have sum of time spent (start date + time & End date + time) by 4 people. I have to calculate gap : [available time] minus [sum...
  2. J

    Converting Dates To Different Formats

    I'm trying to convert a column of dates from the date format of Monday, September 20, 2010 06:15 A.M. (cells are formatted as a DATE with English as the Language) to 2010-09-20 06:15:00 I tried the date formats for different languages. The closest I got was either Danish or Swedish. But...

Some videos you may like

This Week's Hot Topics