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

Top