| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
|
#3
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| unmet challenge | Excel Worksheet Functions | |||
| mulitiplying time | Excel Worksheet Functions | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
