Calculating Total Time Worked on a

Problem: Columns A & B contain the dates and times that a person signed in and out of work. We want to create a new column containing the date...

Finding the First Login and Last Logout Times of Employees

In this article, you’ll learn how to find the first login and last logout times of employees by using Microsoft Excel functions. To solve this query...

Creating a Timesheet

Problem: Creating a timesheet which calculates the number of hours worked each day and a sum of the total hours worked. Solution: Create 3 columns con...

Creating a Date and Time Matrix

Problem: Listed in column A are the dates and times of doctor's appointments. Column B contains the corresponding patient's name for each appointme...

Converting Text, Which Represents Date and Time, Into Proper Date and Time Values

Problem: Column A contains strings which represent dates and times that have been formatted as "mmm d yyyy h:mm:ss PM/AM". We want to extract the ...

How to Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time) in Microsoft Excel

While working on Excel reports and Excel dashboards in Microsoft Excel, we need to convert Date and Time. In addition, we need to get the difference i...

Creating Date and Time Stamp

There may be situations when we need current date and time stamp in Excel. In this article, we will learn how to create date and time stamp by using t...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube