Sign in, Sign out times and total up hours?

J

John

Trying to make a sheet that will let me sign in at work and sign out, then
give me the total hours for the day??? If anyone can help me that would be
great :)

John
 
B

Biff

Hi John,

A1 = 8:10 AM time in
B1 = 11:25 AM time out
C1 = total hrs

In C1 enter:

=B1-A1 formatted as [h]:mm = 3:15

=(B1-A1)*24 formatted as General = 3.25

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft 365 Activations, Users or Devices? 0
Work Budget Salary vs Real Time Salary 0
Summing a Formula 15
Excel: counting times and dates during non-traditional hours 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Zero Occurance 4
Lookup whole sheet and add datas from specified date to end date 0
TIME CALCULATION 8

Top