LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DW DW is offline
external usenet poster
 
Posts: 26
Default How to: Convert time value to a number

Hello,

I have a column that contains cell values of various times, in another
column, I need to change those time values to numbers.

Sheet snippet:

COL A COL B COL C COL D
COL E COL F
Date Time Strt Time End Total Hours for Day 70 Hr Clock Hours Remaining
ROW 1 9/1/2007 8:00 14:00 6:00 6.00 70 - 41.00 70 minues Col E running
tally
ROW 2 9/2/2007 7:00 15:30 8:30 14.50 or
ROW 3 9/3/2007 8:00 15:30 7:30 22.00 29.00
ROW 4 9/4/2007 7:00 15:30 8:30 30.50
ROW 5 9/5/2007 0:00 0:00 0:00 30.50
ROW 6 9/6/2007 0:00 0:00 0:00 30.50
ROW 7 9/7/2007 6:00 14:30 8:30 39.00
ROW 8 9/8/2007 6:00 14:30 8:30 47.50
ROW 9 9/9/2007 7:00 15:30 8:30 47.50 Drops R2 Col E
ROW 10 9/10/2007 0:00 0:00 0:00 40.00 Drops R3 Col E
ROW 11 9/11/2007 6:00 14:30 8:30 41.00 Drops R4 Col E

Col D needs to be in numeric form with 2 decimals and has calculation of
Col C - Col B
Col E needs to tally Col D, but in 8 day cycles. For this posting, Col D and
Col E were added manually to show how it is supposed to look.
What I'm looking for is functions that will convert the time values into
numbers with 2 decimal places and then, for Col E, to keep a running tally
of Col D, but only in 8 day cycles and then in Col F, a calculation to keep
track of remaining "time" (70 - latest Col E amount).

It's a lot and I'm not sure if it's feasible....but any help would be
appreciated.

Don


 
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
Convert Number to Time BenS Excel Discussion (Misc queries) 6 May 16th 08 05:50 PM
Convert number to time NCSemon Excel Discussion (Misc queries) 5 July 3rd 06 07:34 PM
convert number to time JR Excel Worksheet Functions 7 April 3rd 06 07:02 PM
Convert a number to a time Jack Excel Discussion (Misc queries) 4 January 19th 06 09:08 AM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM


All times are GMT +1. The time now is 10:15 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"