ExcelBanter - how do i work out how many hrs have passed in a 24 hr clock, in ex

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

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

- - how do i work out how many hrs have passed in a 24 hr clock, in ex (https://www.excelbanter.com/excel-worksheet-functions/16997-how-do-i-work-out-how-many-hrs-have-passed-24-hr-clock-ex.html)

excelious

how do i work out how many hrs have passed in a 24 hr clock, in ex

does anyone really know the answer to this cos i'm stumped. i've tried
everything.

Arvi Laanemets

Hi

With start and end times entered as times
=EndTime-StartTime+(EndTime<StartTime)
Format the result as time.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets

"excelious" wrote in message
...
does anyone really know the answer to this cos i'm stumped. i've tried
everything.

excelious

thanxs for the help ;)

All times are GMT +1. The time now is 01:17 AM.