Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Outlook Calender Duration Conversion in Excel

Folks,

If I cut and paste my "timesheet" from my Excel Calendar I get the following
column of values for Duration:

1 hour
1 hour
1 hour
1 hour
1.75 hours
15 minutes
30 minutes
2 hours
1.25 hours
1 hour
1 hour
30 minutes
1.25 hours
70 minutes

How can I quickly convert these into minutes and/or minutes and hours?

Many thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
outlook calender jennyandalize Excel Discussion (Misc queries) 0 September 8th 08 06:06 PM
Need to convert Outlook Journal Duration to a number JRO Mtn Group Excel Worksheet Functions 3 May 10th 07 09:01 PM
excel open in outlook if outlook is running kirk Excel Discussion (Misc queries) 0 May 24th 06 06:42 PM
Outlook Calender to Excel Spreadsheet Jason Excel Worksheet Functions 1 January 31st 06 12:11 AM
How do I copy a date from excel to a outlook calender? Pip Excel Discussion (Misc queries) 0 August 5th 05 01:00 PM


All times are GMT +1. The time now is 10:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"