ExcelBanter - Time Card

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time Card (https://www.excelbanter.com/excel-worksheet-functions/18984-time-card.html)

Dan B

Time Card

Hi,
I need help with a formula for a simple time card that does NOT round....so
it will show the exact hours and minutes between a start and stop time, and
then total the hour and minutes in a decimal format.

Thanks,

Dan

Jason Morin

A1: Start Time
B1: End Time

Total Time:

=(B1-A1+(B1<A1))*24

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,
I need help with a formula for a simple time card that
does NOT round....so
it will show the exact hours and minutes between a start
and stop time, and
then total the hour and minutes in a decimal format.

Thanks,

Dan

.

Dan B

Perfect. Thanks!!

"Jason Morin" wrote in message
...
A1: Start Time
B1: End Time

Total Time:

=(B1-A1+(B1<A1))*24

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,
I need help with a formula for a simple time card that
does NOT round....so
it will show the exact hours and minutes between a start
and stop time, and
then total the hour and minutes in a decimal format.

Thanks,

Dan

.

All times are GMT +1. The time now is 11:56 AM.