PC Review


Reply
Thread Tools Rate Thread

converting numbers to Time Range

 
 
Mediaexcel
Guest
Posts: n/a
 
      29th Apr 2004
Hello,

I have two columns with start and end times, however these wer
imported from a pdf file and are not in TIME format. I need to inser
the third column with the time block value, which could be a 30min or
hr. I also have a column with the exact time.

I use the time block values in a formula later in a SUMPRODUCT functio
i.e. ($H$4:$H$457="6-6:30PM")

Any suggestions?

S

Attachment filename: time block example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52889
--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Time to decimals and then converting decimals to time neil_val@tiscali.co.uk Microsoft Excel Worksheet Functions 1 30th Nov 2007 05:09 PM
Converting time to a range of time =?Utf-8?B?c3Vlc2hl?= Microsoft Excel Misc 3 28th Mar 2007 02:14 AM
Converting a "Logged out" time and "logged in" time to find out the elapsed time PamelaB Microsoft Excel Programming 0 12th Dec 2006 06:05 PM
Converting a range of numbers to individual numbers Smythe32@aol.com Microsoft Access VBA Modules 2 30th Nov 2006 06:01 PM
two columns range of numbers need to list all numbers in the range =?Utf-8?B?YXJzb3ZhdA==?= Microsoft Excel New Users 2 30th Oct 2006 09:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:11 AM.