How do I write an Excel formula to calculate my working time?
Reverse the calculation: End time minus start time.
=(a1-A2)*24
Format as general or number, not time
--
Kind regards,
Niek Otten
"GregJ" wrote in message
...
I would like to write a formula where I would input the starting time of a
project or customer call minus the finishing time and then convert that
amount of minutes to tenths of an hour.
Any ideas how?
Thanks
Greg Johnson
|