template or formula for start time -finish time -total hours ple

C

cc

please could I have a formula or function to enter start time-end time and
show total hours/mins for excel
 
P

Peo Sjoblom

=B1-A1

=B1-A1+(A1>B1)

=MOD(B1-A1,1)


with start time in A1 and end in B1 using excel time format hh:mm:ss

the first 2 formulas work if start is before and end is after midnight
 

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

Similar Threads

Printing a specific date & hour in project 0
pieces picked per hour 0
Computing Elapsed Time 4
I'm sure its an easy answer.... 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Calculate After hours 3
24 Hour Clock Calculations 1
Calculate end date and time 1

Top