Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Industrial Time look up sheet

Hello,

I am trying to create a time lookup sheet where at the cross point of Start
and End time the result is shown in 100 of an hour. So Row 1 has the start
time begining at 8.00 am in 15 minutes increments and Colum A has the End
time begining also in 15 minutes increments 8.00 am 8.15 am and so on. Now if
you look for example at End time 10.30 am and go accros and look for Start
time 8.00 am at that cross point the result should say 2.5 (two and a half
hours). I do not know what forumla to write for that. Please help.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default Industrial Time look up sheet

To convert a time into hours, multiply by 24. So you want something like:
(b1-a1)*24
Format as general

Regards
Fred

"Pepino" wrote in message
...
Hello,

I am trying to create a time lookup sheet where at the cross point of
Start
and End time the result is shown in 100 of an hour. So Row 1 has the start
time begining at 8.00 am in 15 minutes increments and Colum A has the End
time begining also in 15 minutes increments 8.00 am 8.15 am and so on. Now
if
you look for example at End time 10.30 am and go accros and look for Start
time 8.00 am at that cross point the result should say 2.5 (two and a half
hours). I do not know what forumla to write for that. Please help.


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
Time Sheet - Calculating Time Differences for Totals Kathy Excel Discussion (Misc queries) 3 January 14th 10 11:04 PM
Industrial Limit Switch Interface with Excel Engatty Excel Discussion (Misc queries) 3 July 11th 07 07:27 PM
Detailed Time Sheet (overtime, comp time, vacation used) Robert D. Sandersfeld New Users to Excel 2 May 22nd 06 10:14 PM
How do I time Hours & mins in excel - Time sheet Helen Excel Discussion (Misc queries) 5 September 17th 05 11:42 AM
I need a time sheet template that verifies time entered against sy Bob Powell Excel Discussion (Misc queries) 1 April 19th 05 03:11 PM


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

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"