ExcelBanter - HOURS CALCULATION

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

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

- - HOURS CALCULATION (https://www.excelbanter.com/excel-discussion-misc-queries/116850-hours-calculation.html)

Stuart Carnachan

HOURS CALCULATION

Would like to calculate no of hours in a specied shift. I can do this until
foe example start time is 22:00 and end time is 04:00 next day - Can somebody
help ?

--
Stuart

Lori

HOURS CALCULATION

If A1 is start time and B1 is end time:

=MOD(B1-A1,1)

(make sure the result in time format.)

Stuart Carnachan wrote:

Would like to calculate no of hours in a specied shift. I can do this until
foe example start time is 22:00 and end time is 04:00 next day - Can somebody
help ?

--
Stuart

Stuart Carnachan

HOURS CALCULATION

Fantastic
--
Stuart

"Lori" wrote:

If A1 is start time and B1 is end time:

=MOD(B1-A1,1)

(make sure the result in time format.)

Stuart Carnachan wrote:

Would like to calculate no of hours in a specied shift. I can do this until
foe example start time is 22:00 and end time is 04:00 next day - Can somebody
help ?

--
Stuart

All times are GMT +1. The time now is 02:36 AM.