LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
tankerman
 
Posts: n/a
Default how do i get this

I have dates and times i have to add and substract from each other most are
start and finish time except for 1 of them and i'm having trouble with it.
after i add them together which gives me the amount of hours and minutes the
process took but i have to subtract the delay time which is figured in hours
and minutes on a seperate sheet that i just incert into a cell in the
spreadsheet. my trouble is getting the process hr and min. time to subtract
from the delay cell, the delay in a time format gives me AM & PM time frames
in stead of an hr time frame. i cann't seem to figure out how to get this
done.
 
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



All times are GMT +1. The time now is 06:41 PM.

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

About Us

"It's about Microsoft Excel"