When I export to Excel the task list with time related columns like Actual Time or Estimated Time, I get some strange numbers which are not related to time.
MS Excel supports date format (ex.: 10.46 pm), but doesn't support time period format (ex.: 10 hours and 46 minutes). That's why it can not display time period correctly. Here are the instructions and the formula you can use to have adequate numbers in your columns:
-
Export task list to Excel
- Enter this formula to a cell in an empty column:
- Formula: =IF(S5<1/24;CONCATENATE(TEXT(S5/(1/(24*60));"#0");"min");IF(S5<1;CONCATENATE(TEXT(S5/(1/24);"#0,0");" hour(s)");CONCATENATE(TEXT(S5;"0,0");" day(s)")))
- Instead of each 'S5' should be the cell where the 'actual time' is imported.
- Apply this formula to other cells (by dragging the right bottom edge of the first cell in the column down.
|
|
Skype
Available: Workdays, Monday - Friday
8 am - 8 pm GMT for Europe/Asia
1 am - 1 pm PST for America
|
|
|
|
Feb 1, 2016
TopTenReview: VIP Organizer is one of the best organizer software
TopTenReview has published Organizer Software Review 2016 and our product has been included to the list of the best software programs for personal information management. The author considers VIP Organizer to be a good choice if you are looking for something simple to help you organize your days.
More News
|
|
|
|