time and date stamp

  1. N

    Multiple IF statement - calculate fees excluding certain hours of the day

    I have a data set that gives me all 'electric charge' transactions in a particular month. From the data, we can see when a charge is initiated, when a charge is complete, and when a charge is unplugged (ended). I am trying to figure out how much in penalties we would have accrued if we...
    • nam24
    • Thread
    • excel multi if formula time and date stamp
    • Replies: 12
    • Forum: Excel Questions
  2. P

    create a queue for jobs

    Hello experts, (See attached example workbook) I would like excel to automatically create a Textbox (or anything else that you may think suitable) in the "Job Basket" tab when Column B of "Job List" tab is filled in with a time. Other features I would like to have: -The users can use the "Job...
  3. L

    Adding Hours Based on Time Zone

    Hi All, I am having some trouble adjusting the hours based on Time Zone. For context, I have a dataset where the date / time in column AC is all in EST. I want to adjust this based on Time Zone. In column AK I used =TIME(HOUR(AC2),0,0) to pull out the hour + AM / PM. However, I want to adjust...
    • lpw0806
    • Thread
    • time & date time and date time and date stamp time based formula
    • Replies: 16
    • Forum: Excel Questions
  4. D

    time and date stamp in VBA form

    Currently new to using VBA and im looking to make a code for the time and date stamp that is automatically updated to the current day and time. Basically automatically being shown then when you hit save on the document, it captures that and sends it with the other information into a spreadsheet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top