I've determined I don't like working with time in Excel, LOL
Ive googled, printed out how to's and searched here but nothing I have seen and tried seems to be working the way I need.
My workbook contains imported data that is done so automatically via a VBA script. The amount of data can be from just a few rows to a couple hundred. One of those columns imported is a time stamp column that contains a date and a time (Column B). What I need is to determine the number of hours from the point of that time stamp to now in hours, minutes, seconds in Column F.
I added something of a helper in Q1 that keeps and updates, via VBA, the current time each time the sheet is activated. I would like to base the calculation off that since it would result in everything else being updated, which is what I would like to do.
The second part to this, and I may need to post in the VBA section for this and if so just let me know, is that since the number of rows will vary from one import to next, I would like to just fill Column F with whatever formula is needed there just down to the last used row. I am open to suggestions and ideas here. If all of this needs to be done with VBA then so be it as long as I can get hours, minutes, and seconds in Column F.
Bookmarks