Skip to content

Excel for Engineers

  • Excel for Engineers – Home
  • Training
  • Blog
  • About
  • Contact
Excel for Engineers

Times

Tips and Techniques

Working with Times in Excel: A Timesheet Example

ByRick April 19, 2023April 20, 2023

This post follows on from the discussion of time formats in the post: Working with Times in Excel. If you would like a copy of the sample file Timesheet.xlsx used in this post, click here and send the resulting email.  Otherwise, you can build up the file as discussed below. 1.     Setting up the Time…

Read More Working with Times in Excel: A Timesheet ExampleContinue

Excel Functions | Tips and Techniques

Working With Times in Excel

ByRick November 22, 2022April 20, 2023

Microsoft Excel stores dates as sequential serial numbers for use in calculations. 1 January 1900 is serial number 1. 2 January 1900 is serial number 2, and so on.  Thus, 1 January 2000 is serial number 36526 because it is 36,525 days after 1 January 1900. Logically, a time of day is a fraction of…

Read More Working With Times in ExcelContinue

© 2025 Excel for Engineers - WordPress Theme by Kadence WP

  • Excel for Engineers – Home
  • Training
  • Blog
  • About
  • Contact