ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   timecard (https://www.excelbanter.com/excel-discussion-misc-queries/177855-timecard.html)

vdmbqb

timecard
 
I need a simple formula.

Cell A1 is begin time and cell B1 is end time, both are entered in hours and
minutes.
I need the formula in C1 for the difference between the two in hours and
minutes.

Thank you SO SO Much
--
bob

Max

timecard
 
Assume in-out times entered in cols A and B from row2 down like this

In Out
8:00 18:00
etc

Put in C2, copy down: =B2-A2
will return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"vdmbqb" wrote:
I need a simple formula.

Cell A1 is begin time and cell B1 is end time, both are entered in hours and
minutes.
I need the formula in C1 for the difference between the two in hours and
minutes.

Thank you SO SO Much
--
bob



All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com