Ask Your Question

Looking for a formula to find the difference between two hour:minute times from a timecard and convert the difference into decimal hours [closed]

asked 2014-03-15 02:03:10 +0200

purevw gravatar image

Example: Clock in at 8:00 and out at 16:00 The difference would be 8.00 hours.

I want to create a spreadsheet where I simply enter the times from the time cards (24 hour format) and get decimal hours as the output. The company I work for calculates time-card times to two digits after the decimal. For example, 8.03 hours.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:06:23.591884

2 Answers

Sort by » oldest newest most voted

answered 2014-03-15 17:02:02 +0200

purevw gravatar image

Thanks to mariosv. I was able to use his answer to come up with the following formula in D2:


With B2 being the start time and C2 being the end time. Columns B and C are formatted as time and D is formatted as numbers with two digits following the decimal.

edit flag offensive delete link more

answered 2014-03-15 04:10:23 +0200

m.a.riosv gravatar image

You can enter the times with the format
A1: hh:mm
and in other cell calculate the hour with two decimals:
B1: =ROUND(A1*24;2)

For exact hours you can enter the hour with a colon without the minutes

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-03-15 02:03:10 +0200

Seen: 7,077 times

Last updated: Mar 15 '14